Search Results
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Figure 3.15 Preferences: Modeling: Appearance Color Presets These are the available colors used while modeling, and they are divided into two sections. This section provides configuration options that affect the modeling functionality in MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-preferences.html
The Workbench Preferences sidebar menu is divided into the following sections: General Editors: General-purpose editor options, such as SQL parsing options. Select Preferences from the Edit menu to configure MySQL Workbench to your specific needs.
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
If there is no CREATE DATABASE db_name statement in your script file, you must import the database objects into an existing schema or, if there is no schema, a new unnamed schema is created. To reverse-engineer a database using a create script, do ...
https://dev.mysql.com/doc/workbench/en/wb-routines-routine-groups.html
MySQL Workbench unifies both stored procedures and stored functions into one logical object called a Routine. You can add Routine Groups to a database either from the Physical Schemata section of the MySQL Model page or from an EER Diagram.
https://dev.mysql.com/doc/workbench/en/wb-scripting-shell-window.html
While individual commands can be entered into the shell, it is also possible to run a longer script, stored in an external file, using the main menu item Scripting, Run Workbench Script File. The Workbench Scripting Shell is primarily used for ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-toolbar.html
Figure 8.3 SQL Query Toolbar SQL query tools (from left to right) are: Open a script file in this editor: Loads content from a saved SQL script into the SQL editor. The SQL query toolbar provides actions that enable you to create and manage queries. The following figure shows the set buttons in the toolbar, located within the SQL query ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
You can merge (or separate) the content of the two tabs into a single list by clicking merge (). The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Note ENUM, BIT, and SET must contain at least one value when entering these data types into MySQL Workbench. 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 ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
To enable partitioning for your table, check the Enable Partitioning check box. This enables the partitioning options (shown in the figure that follows). Figure 8.18 The Partitioning Tab The Partition By pop-up menu displays the types of partitions ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
You can also double-click the table to load it into the table editor. 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 a tool changes the ...