PDF (US Ltr)
- 17.0Mb
PDF (A4)
- 17.0Mb
Search Results
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
The next figure shows an example that adds table locks, uses replace instead of insert statements, quotes identifiers with backtick characters, and so on. Use this wizard to either export or import SQL generated from MySQL Workbench or with the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-migration.html
The steps performed include Migrating the selected objects, and generating the SQL CREATE statements, as indicated in the next figure. Reverse engineered objects from the source RDBMS are automatically converted to MySQL compatible objects. Default ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-live-server.html
Figure 9.45 Forward Engineering Progress You can confirm that the script created the schema by connecting to the target MySQL server and issuing a SHOW DATABASES statement. Use forward engineering to export your schema design to a MySQL server.
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 release. Overlay Icons in the Object Viewer The schema navigator now includes shortcut buttons for common operations such as table ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
Together the editors and panels enable you to: Build, edit, and run queries Create and edit data View and export results Perform basic RDBMS administrative tasks Color syntax highlighting, context help, and code completion assist you in writing and ... The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and output ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html
The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill statements and connections, and view additional connection details and attributes. The following figure shows an example of client ...
https://dev.mysql.com/doc/workbench/en/wb-views-physical-schemata.html
Copy SQL to Clipboard copies the CREATE VIEW statement to the clipboard. 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 already exists, the new view is named view2.
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
Both models derive from MySQL database samples (see https://dev.mysql.com/doc/index-other.html), which you can download and use to explore the MySQL Workbench modeling interface. MySQL Workbench represents each active data model as an icon in the ...
https://dev.mysql.com/doc/workbench/en/wb-properties-palette.html
expanded: This attribute applies to objects such as tables that can be expanded to show columns, indexes, and triggers. Tables have the following additional properties: indexesExpanded: Whether indexes are displayed when a table is placed on the ...
https://dev.mysql.com/doc/workbench/en/wb-develop-object-management-inspector.html
Figure 8.23 Schema Inspector Each tab lists topic-oriented information in categories, such as tables, indexes, and triggers. The Table Inspector includes an easy-to-use interface for analyzing and creating indexes for your tables. The Schema ...