Search Results
https://dev.mysql.com/doc/workbench/en/wb-data-modeling.html
Modeling simplifies database design and maintenance by enabling you, the data architect, to visualize requirements and resolve design issues. Model-driven database design is an efficient methodology for creating valid and well-performing databases, ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
The results area of the screen shows the results from executed statements. If the script contains multiple statements, a result subtab will be generated for each statemented that returned results. The following figure shows a single subtab and ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-live-server.html
As the following figure shows, the Select Objects page enables you to select the objects to forward engineer: Table objects, view objects, routine objects, trigger objects, and user objects. Use forward engineering to export your schema design to a ...
https://dev.mysql.com/doc/workbench/en/wb-importing-sql-script.html
Tables appear at the top followed by views and then routines. For this tutorial, use the sakila database script, which you can find by visiting the https://dev.mysql.com/doc/index-other.html page. Open MySQL Workbench, select the models view from ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-supported.html
Generally speaking, only table information and its data are automatically converted to MySQL. When a supported RDBMS product is being migrated, the MySQL Workbench Migration Wizard will automatically convert as much information as it can, but you ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-manual-editing.html
Figure 10.58 MySQL Workbench Migration: Manual Editing (All Objects) Column Mappings: Shows all of the table column mappings and enables you to individually review and fix the mapping for all column types, default values, and other attributes. Use ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-schema-creation.html
Table data will be migrated in a later step as well. The SQL scripts generated for the migrated schema objects will now be executed in the target database. You can monitor execution in the logs, if errors exist then they will be fixed in the next ...
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The following figure shows the film table object from the sakila schema with INDEX, INSERT, SELECT, and TRIGGER selected for the role1 role. The Schema Privileges panel has the following sections, used to create users for your schemas and to define ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html
Figure 5.29 Client Connections Details Locks: MySQL uses metadata locking to manage access to objects such as tables and triggers. The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
To open the Administration - Users and Privileges tab: Establish a connection to an active MySQL server instance. For example, if you select the role BackupAdmin, the privileges granted include EVENT, LOCK TABLES, SELECT, SHOW DATABASES. The ...