Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-4-0.html
For users of MySQL Enterprise Edition, JSON duality views can be modified using INSERT, UPDATE, or DELETE statements, so that updates of such a view cause corresponding updates on the base table. As a result, temporary table field references from ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-5-0.html
(Bug #38033684) Large TIME values inserted into a TIME column became smaller when converted to JSON. (Bug #38187473) INSERT statements for a JSON Duality View that included an AUTO_INCREMENT column were rejected even if the column was not part of a ... Note These release notes were created with the assistance of MySQL HeatWave ...
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-audit-inspector.html
MySQL Workbench offers a graphical interface to MySQL Enterprise Audit. To activate the audit_log plugin manually using mysql, load the plugin code from the library file at runtime with the INSTALL PLUGIN statement. On Windows: INSTALL PLUGIN ...
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 ...