Search Results
https://dev.mysql.com/doc/refman/8.4/en/condition-handling-restrictions.html
SIGNAL, RESIGNAL, and GET DIAGNOSTICS are not permissible as prepared statements. For example, this statement is invalid: PREPARE stmt1 FROM 'SIGNAL SQLSTATE "02000"'; SQLSTATE values in class '04' are not treated specially. In standard SQL, the ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
The SOURCE_COMPRESSION_ALGORITHMS and SOURCE_ZSTD_COMPRESSION_LEVEL options for the CHANGE REPLICATION SOURCE TO statement configure permitted compression algorithms and zstd compression level for replica servers participating in source/replica ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). To set the relevant variables at server startup, put these lines in the ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
It implements a thread pool that increases server performance by efficiently managing statement execution threads for large numbers of client connections. When the thread stack is too small, this limits the complexity of the SQL statements the ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. MySQL system tables still exist in MySQL 8.4 and can be viewed by issuing a SHOW TABLES statement on the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
The primary use case is modification of statements restored from dump files, so the typical usage pattern is: 1) Install the plugin; 2) restore the dump file or files; 3) uninstall the plugin. To install the ddl_rewriter plugin, use the INSTALL ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
For example, to load the JSON log sink, issue the following statement: INSTALL COMPONENT 'file://component_log_sink_json'; Loading a component using INSTALL COMPONENT registers it in the mysql.component system table so that the server loads it ...
https://dev.mysql.com/doc/refman/8.4/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.