Search Results
https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html
Altering the table by adding indexes or other features is also possible using the table editor by clicking each tab within the table editor. Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure ...
https://dev.mysql.com/doc/workbench/en/wb-intro.html
The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. This chapter provides general information about MySQL Workbench and how it has ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
At this point, the migration wizard is retrieving relevant information about the involved database objects (such as table names, table columns, primary and foreign keys, indexes, triggers, views, and more). General Information Microsoft Windows is ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
Index Yes Yes Yes Yes Information Schema Yes No Yes Yes Object Names Case Sensitivity Depends on collation Depends on collation Mixed Mixed MySQL: sensitivity of database, table, and trigger names OS dependent; other object names are not ... The ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview.html
The Migration Wizard performs the following steps when migrating a database to MySQL: Connects to the source RDBMS and retrieves a list of available databases/schemas. Reverse engineers selected database/schemas into a internal representation ...
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-routines.html
The privileges that display are: ALL CREATE DROP GRANT OPTION REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER You can choose to assign all privileges to a specific role or any other privilege as listed previously. 9.1.6.1.1 Adding ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
SQL DDL (SQL Data Definition Language): Syntax examples include creating, altering, and dropping tables, indexes, views, and procedures. The Snippets secondary tab includes built-in, local, and shared custom snippets. The My Snippets option stores ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
The entries in this table are: Partition Values Data Directory Index Directory Min Rows Max Rows Comment Subpartitioning is also available. To enable partitioning for your table, check the Enable Partitioning check box. This enables the ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor.html
You can add or modify the columns or indexes of a table, change the engine, add foreign keys, or alter the table name. The MySQL Table Editor is a used to create and modify tables. To access the MySQL Table Editor, right-click a table name in the ...