Search Results
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Generate DROP SCHEMA Sort Tables Alphabetically When this option is unchecked, tables are sorted according to foreign-key references. Skip creation of FOREIGN KEYS Skip creation of FK Indexes as well Omit Schema Qualifier in Object Names Select this ... Forward engineering enables you to create a script of your database ...
https://dev.mysql.com/doc/workbench/en/wb-history-palette.html
You can select multiple contiguous entries by pressing the Shift key and clicking the entries you wish to copy. Use the History palette to review the actions that you have taken. Left-clicking an entry opens a pop-up menu with the item, Copy ...
https://dev.mysql.com/doc/workbench/en/wb-modules.html
In the GRT Modules are libraries containing a list of functions that are exported for use by code in other modules, scripts, or Workbench itself. Modules can be written in C++ or Python, but the data types used for arguments and the return value ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-standard.html
This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. In addition to naming your new connection in the field provided, you can select from the following tabs to specify connection values: Parameters, SSL, and ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Prevents UPDATE and DELETE queries that lack a corresponding key in a WHERE clause, or lack a LIMIT clause, from executing. When selected, this preference makes it possible to catch UPDATE and DELETE statements with keys that are not used properly ... This section provides configuration options that affect the SQL editor functionality in MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-routines.html
Navigate between different tabs using the mouse or from the keyboard by pressing Control+Alt+Tab. Use the Shift key to select multiple contiguous roles and the Control key to select noncontiguous roles. 9.1.6.1.1 Adding Routines to the Physical ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-main-window.html
Any number of tables may be edited in the MySQL Table Editor at any one time. Adding another table creates a new secondary tab at the top of the editor. 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-options-tab.html
General Options Section In the General Options section, choose a pack keys option. The AUTO_INCREMENT and delayed key update behaviors apply only to MyISAM tables. The Options subtab enables you to set several types of options. Figure 8.19 The ...
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-using-layer-tool.html
You can also change the mouse pointer to a layer pointer by pressing the L key. You cannot remove them by clicking and dragging; to remove an object, you also must press the Control key while dragging it. To add layers to an EER Diagram, use the ...