Search Results
https://dev.mysql.com/doc/refman/8.4/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.4/en/case.html
CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN statement_list [WHEN search_condition THEN statement_list] ... [ELSE statement_list] ...
https://dev.mysql.com/doc/refman/8.4/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
To use this statement, you need the CREATE privilege for the database. CREATE DATABASE is not permitted within a session that has an active LOCK TABLES statement. To see the available character sets and collations, use the the SHOW CHARACTER SET and ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. (CREATE FUNCTION is also used to created stored functions; ...
https://dev.mysql.com/doc/refman/8.4/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. For each of them to be installed, use a separate INSTALL PLUGIN statement. Each statement names a different plugin, but all of them specify the same ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
Executing the LOCK INSTANCE FOR BACKUP statement requires the BACKUP_ADMIN privilege. REPAIR TABLE TRUNCATE TABLE, OPTIMIZE TABLE, and account management statements are blocked. PURGE BINARY LOGS cannot be issued while a LOCK INSTANCE FOR BACKUP ...
https://dev.mysql.com/doc/refman/8.4/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
The privileges required for RESET PERSIST depend on the type of system variable to be removed: For dynamic system variables, this statement requires the SYSTEM_VARIABLES_ADMIN privilege (or the deprecated SUPER privilege). For read-only system ...