Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-character-set.html
SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...
https://dev.mysql.com/doc/refman/8.4/en/set-default-role.html
SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} TO user [, user ] ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
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 Groups”). Thread IDs can be determined from the Performance Schema threads table. If the ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not specify 'log_name', the first binary log is displayed. The LIMIT clause has the same syntax as for the SELECT statement.
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. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL ...
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. For the current user, the ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
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. It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. A ...