Search Results
https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html
Click the Tab key to move to the next column and set the column's data type. Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure shows. This action opens the table editor docked at the bottom ...
https://dev.mysql.com/doc/workbench/en/wb-creating-eer-diagram.html
Figure 9.30 Adding Tables to the Canvas MySQL Workbench automatically discovers that address.city_id has been defined as a foreign key referencing the city.city_id field. Save your changes to a MySQL Workbench model file (.mwb extension) by choosing ... To create an EER diagram for the sakila database, first add an EER diagram by double-clicking the Add Diagram icon in the EER Diagrams panel to create and open a new EER Diagram ...
https://dev.mysql.com/doc/workbench/en/wb-eer-diagrams-section.html
To get started, review the diagram editor's color key and vertical toolbar. Enhanced Entity-Relationship (EER) diagrams are an essential part of the modeling interface in MySQL Workbench. EER diagrams provide a visual representation of the ...
https://dev.mysql.com/doc/workbench/en/wb-exploring-scripting-shell.html
You can also open the Workbench Scripting Shell using the Control + F3 key combination on Windows and Linux, Command + F3 on macOS, or by clicking the shell button above the EER diagram navigator. To open the Workbench Scripting Shell, select ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
An account that authenticates with caching_sha2_password must use either a secure connection or an unencrypted connection that supports password exchange using an RSA key pair. The Administration - Users and Privileges tab provides a list of all ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-server-management-wizard.html
If you do not enter the optional SSH Key for use with the server, then you will be prompted for the password when the connection is established by MySQL Workbench. Clicking the [+] icon from the home screen launches the Setup New Connection wizard.
https://dev.mysql.com/doc/workbench/en/wb-navigator-panel.html
If the slider tool has the focus, you can also zoom using the arrow keys. Docked at the top left of the application is the Model Navigator, or Bird's Eye panel. This panel provides an overview of the objects placed on an EER diagram canvas and for ...
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
This section provides configuration options that affect the modeling functionality in MySQL Workbench (see the figure that follows). Force use of software based rendering for EER diagrams MySQL Workbench uses OpenGL for rendering when available.
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Tables, views, routines, routine groups, indexes, keys, and constraints can be imported from an SQL script file. To reverse-engineer a database using a create script, do one of the following: On the home screen, select the model view from the ...