Search Results
https://dev.mysql.com/doc/refman/8.4/en/table.html
Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced by TABLE using ORDER BY and LIMIT clauses, respectively. For limiting which ... TABLE is a DML statement which returns rows and columns of the named ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The algorithm names zstd_stream, lz4_message, and deflate_stream can be specified in any combination, and the order and lettercase are not important. If the server and client permit more than one algorithm in common, the default priority order for ... X Plugin supports compression of messages sent over X Protocol ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html
In the simplest case, a template consists of two files: a template file, which has a .tpl extension, and a special file info.xml. A third file is optional, which is the preview image file. This preview file provides a thumbnail image illustrating ...
https://dev.mysql.com/doc/workbench/en/wb-accessibility.html
MySQL Workbench includes options to improve user accessibility that you can select from the Workbench Preferences dialog. To open the dialog, click Edit and then Preferences from the menu. Fonts Modeling fonts are adjustable from the Appearance ...
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. Access these wizards from either the Navigator area of the sidebar, or by selecting Server from the main menu, and then either Data Import ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html
Export or Import data directly from or into the result set. The export and import operations shown in this section apply to result data only. For an overview of the various data export and import options in MySQL Workbench, see Section 6.5, “Data ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html
This wizard supports import and export operations using CSV and JSON files, and includes several configuration options (separators, column selection, encoding selection, and more). The wizard can be performed against local or remotely connected ...
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-design-engineering.html
MySQL Workbench provides capabilities to forward engineering physical database designs. A visual data model can be transformed into a physical database on a target MySQL Server by executing the forward engineering wizard. All SQL code is ...