Search Results
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
A non-identifying relationship: identified by a broken (dashed) line between tables Create or drag and drop the tables that you wish to connect. Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. In ...
https://dev.mysql.com/doc/workbench/en/wb-routines.html
The privileges that display are: ALL CREATE DROP GRANT OPTION REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER You can choose to assign all privileges to a specific role or any other privilege as listed previously. 9.1.6.1.1 Adding ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Use the Columns subtab to display and edit all the column information for a table. You can also use the Columns subtab to change column properties such as name, data type, and default value. Figure 8.14 The Columns Tab Right-click a row under the ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The options are: RESTRICT CASCADE SET NULL NO ACTION To drop a foreign key, right-click the row you wish to delete, then select the Delete Selected FKs menu item. The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
They may be added to an EER Diagram by dragging and dropping them from this palette. 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 ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
Use the drop-down list to switch between the visual and tabular representations. This tutorial describes how to use Explain reports to locate and fix problematic (slow) queries. It uses the DBT-3 database and begins with the following simple query ...
https://dev.mysql.com/doc/workbench/en/wb-using-layer-tool.html
9.1.7.1.1 Adding Objects to a Layer To add an object to a layer, drag and drop it directly from the Catalog palette onto a layer. To add layers to an EER Diagram, use the Layer tool on the vertical toolbar. Select an EER Diagram tab and left-click ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
After a text object has been dropped on the canvas, the mouse pointer reverts to its default. The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is selected. Figure 9.12 The Vertical Toolbar Clicking ...
https://dev.mysql.com/doc/workbench/en/wb-views-physical-schemata.html
They may be added to an EER Diagram, when in the EER Diagram tab, by dragging and dropping them from this palette. 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 ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
This section summarizes many of the new features added to MySQL Workbench 6.1, in relation to the MySQL Workbench 6.0 release. New Navigator PERFORMANCE Section Server Variable Groupings SQL Editor Views Home Screen Features Visual Explain Table ...