Search Results
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
Create an index prefix by specifying a numeric value under the Length column. 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 ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-main-window.html
Adding another table creates a new secondary tab at the top of the editor. Any number of tables may be edited in the MySQL Table Editor at any one time. By default, the MySQL Table Editor appears docked at the top of the table editor tab, within ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
Figure 8.18 The Partitioning Tab The Partition By pop-up menu displays the types of partitions you can create: HASH LINEAR HASH KEY LINEAR KEY RANGE LIST Use the Parameters field to define any parameters to be supplied to the partitioning function, ... To enable partitioning for your table, check the Enable Partitioning check ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-triggers-tab.html
The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT. To add a new trigger, click the [+] icon ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor.html
The MySQL Table Editor is a used to create and modify tables. You can add or modify the columns or indexes of a table, change the engine, add foreign keys, or alter the table name. To access the MySQL Table Editor, right-click a table name in the ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
Copy SQL to Clipboard: Copies a CREATE TABLE statement for the table. Double-clicking the Add table icon in the Physical Schemas section of the Model Overview tab adds a table with the default name of table1. If a table with this name already ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins.html
The tutorials in this section demonstrate how to extend MySQL Workbench by creating custom plugins.
https://dev.mysql.com/doc/workbench/en/wb-tutorials.html
Creating a database from scratch is the focus of Section 9.3.4, “Using the Default Schema” and exploring the graphic design capabilities of MySQL Workbench is touched upon in Section 9.3.2, “Basic Modeling”. This chapter contains three ...
https://dev.mysql.com/doc/workbench/en/wb-view-editor.html
Enter the SQL to create a view using the SQL field. To invoke the view editor, double-click a view object on the EER Diagram canvas or double-click a view in the Physical Schemas section on the MySQL Model page. This opens the view editor docked at ...
https://dev.mysql.com/doc/workbench/en/wb-views-physical-schemata.html
Copy SQL to Clipboard copies the CREATE VIEW statement to the clipboard. To add a view, double-clicking the Add View icon in the Physical Schemas section of the MySQL Model page. If a view with this name already exists, the new view is named view2.