PDF (US Ltr)
- 17.0Mb
PDF (A4)
- 17.0Mb
Search Results
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Skip creation of FOREIGN KEYS Skip creation of FK Indexes as well Omit Schema Qualifier in Object Names Select this option to generate unqualified object names in SQL statements. Generate USE statements Generate Separate CREATE INDEX Statements ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
If enabled, the import operation makes a spatial index around the geometry column. This executes a USE schema_name statement so that subsequent statements without schema qualifiers are executed against this schema. Copy to Clipboard: Copies the ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab and adding or editing a foreign key is similar to adding or editing an index. Enter a name for the foreign key and select the column or columns that you wish to ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
MySQL Workbench handles the script as follows: If the script does not contain a CREATE DATABASE db_name; statement, the schema objects are copied to the initial schema, named mydb by default. Export: Generates the SQL statements necessary to create ... Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-main-menu.html
Collect Performance Schema Stats: Provides data to the Query Stats result set view, which includes statement specific information about Timing, Rows processed, Temporary tables, Joins per type, Sorting, and Index usage. SQL Query Menu The Query menu ... When an SQL query tab is selected, the most important items on the main menu bar are the Query and Edit ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
Figure 1.23 Status And System Variables: Custom SQL Editor Views Additional viewing options were added for executed statements: Result Grid Available previously, and it remains the default view. Figure 1.26 SQL Editor: Field Types Query Stats Query ... This section summarizes many of the new features added to MySQL Workbench 6.1, in relation to the MySQL Workbench 6.0 ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
Can I preserve a results tab rather than have it refresh every time I execute a statement? A.5. The SQL statement history is stored as plain text on your system under your user's MySQL Workbench configuration path in the sql_history directory. These ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
Both models derive from MySQL database samples (see https://dev.mysql.com/doc/index-other.html), which you can download and use to explore the MySQL Workbench modeling interface. MySQL Workbench represents each active data model as an icon in the ...
https://dev.mysql.com/doc/workbench/en/wb-properties-palette.html
expanded: This attribute applies to objects such as tables that can be expanded to show columns, indexes, and triggers. Tables have the following additional properties: indexesExpanded: Whether indexes are displayed when a table is placed on the ...
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
Figure 9.15 A Table on an EER Diagram As shown in the preceding figure, the primary key is indicated by a key icon and indexed fields are indicated by a different colored diamond icon. Toggle the display of indexes and triggers in the same way.