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-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-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. SMALLINT SMALLINT BIGINT BIGINT ...
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-performance-dashboard.html
Data points include the Table Open Cache efficiency, SQL Statements Executed, and counts (per second) for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements. To display the dashboard, open a query tab and then click Dashboard from ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Use UPPERCASE keywords on completion Normally keywords are shown and inserted as they come from the code editor's configuration file. This section provides configuration options that affect the SQL editor functionality in MySQL Workbench. Permits ...
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-query-panel.html
The item name will be inserted into the SQL Query panel. The SQL query secondary tab opens by default when you make a connection to a server from the Home screen. You can enter SQL statements directly into the query editor area. The statements ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
You may specify the action the server should take when users attempt to perform INSERT statements on the merge table. The Options subtab enables you to set several types of options. Figure 8.19 The Options Tab Table options are grouped into the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS MASTER_COMPRESSION_ALGORITHM MASTER_TLS_CIPHERSUITES MASTER_ZSTD_COMPRESSION_LEVEL MEMBER OFF PASSWORD_LOCK_TIME PRIVILEGE_CHECKS_USER RANDOM REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ...