PDF (US Ltr)
- 17.0Mb
PDF (A4)
- 17.0Mb
Search Results
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
The Indexes subtab contains all of the index information for your table. The following figure shows an example of the layout with the PRIMARY index of the customer table selected and both the index columns and index options shown. Figure 8.15 The ...You cannot enter a prefix value for fields that have a data type that does not support ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
PK: PRIMARY KEY NN: NOT NULL UQ: UNIQUE INDEX BIN: BINARY UN: UNSIGNED ZF: ZEROFILL AI: AUTO_INCREMENT G: Generated Column This option is available as of MySQL Server 5.7. If you wish to create a composite primary key you can select multiple columns ... Use the Columns subtab to display and edit all the column information for a ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
In such cases, the primary key is usually a composite key made up of the primary keys from the two original tables. Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. A non-identifying relationship: ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
After reviewing the query again, consider that a multiple-column index can meet the conditions of the WHERE clause that is based on both the o_orderdate and o_clerk columns as the next statement shows. Next, an Explain report was generated by ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the extended JSON format. For information about how MySQL executes statements, see Optimizing ...
https://dev.mysql.com/doc/workbench/en/wb-performance-reports.html
Reports help analyze IO hotspots, discover high cost SQL statements, and review wait statistics and InnoDB engine metrics. Performance Report Descriptions Figure 7.4 Performance Reports: Statement Analysis Individual reports are shown in the ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-markers.html
These markers can be used in any template, including custom templates. Using the table The table shows which variables are defined in which sections. The variable should be used in its correct section or its value will not be displayed. If a ...
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-what-is-new-8.html
New requirements for the CHANGE MASTER TO replication statement (row format, primary key check). Failed login attempts and password lock time in ALTER USER statements. New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS ... This section summarizes ...