Search Results
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
Use this wizard to either export or import SQL generated from MySQL Workbench or with the mysqldump command. For an overview of the data export and import options in MySQL Workbench, see Section 6.5, “Data Export and Import”. Data Export This ...Access these wizards from either the Navigator area of the sidebar, or by selecting Server from the main menu, and then either Data Import or Data ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
Note MySQL Workbench handles quoting and escaping for strings entered into the result grid, so adding quotes and proper escaping here is optional. Use the prefix \func to prevent MySQL Workbench from escaping quotation marks. For example, for the ...
https://dev.mysql.com/doc/workbench/en/wb-views-overview-scripts.html
Use the SQL Scripts panel to attach SQL scripts to the model for documentation and organizational purposes, and optionally these attachments can be included in the output script when performing forward engineering or model/schema synchronization.
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the shape_predictions table in the mysql_autopilot schema on the MySQL server. The MySQL HeatWave Console ...
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between the MySQL and standard SQL privilege systems. For example, in ...You must explicitly issue a REVOKE statement to revoke privileges for a ...
https://dev.mysql.com/doc/refman/8.4/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The tuning guidelines in this section help to speed up all kinds of MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-connection-information-panel.html
Figure 8.21 SQL Editor - Connection Information Palette The Object Info tab of the Information panel summarizes information about a specific object, such as a table. The Session tab of the Information panel summarizes the current connection to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. You can also invoke mysql with the --verbose option, ...To do so, create a text file text_file that contains the statements you wish to ...