Search Results
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...A ...
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. The SAVEPOINT statement ...If the current transaction has a savepoint with the same name, the old savepoint is deleted and a new one is ...
https://dev.mysql.com/doc/refman/8.4/en/set-default-role.html
For each user named immediately after the TO keyword, this statement defines which roles become active when the user connects to the server and authenticates, or when the user executes the SET ROLE DEFAULT statement during a session. On the other ...
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
With no FOR clause, the statement assigns the current thread for the session to the resource group. With a FOR clause that names thread IDs, the statement assigns those threads to the resource group. SET RESOURCE GROUP statements are not written to ... SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. SHOW CREATE TABLE shows the row format that was specified in the CREATE TABLE statement.
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system schema, except to see information for the current user. row ...For the current user, ...
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/show-errors.html
SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORS SHOW ERRORS is a diagnostic statement that is similar to SHOW WARNINGS, except that it displays information only for errors, rather than for errors, warnings, and notes. The LIMIT clause ...You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A similar statement, SHOW FUNCTION STATUS, displays information about stored functions (see Section 15.7.7.21, “SHOW FUNCTION STATUS Statement”). To use ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). You can specify user credentials for distributed recovery in the START GROUP_REPLICATION statement using the USER, PASSWORD, and DEFAULT_AUTH options, ... START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group ...