SQL commands for administering MariaDB.
-
BINLOG
Syntax: BINLOG 'str'Description: BINLOG is an internal-use statement. It i... -
CACHE INDEX
Syntax CACHE INDEX tbl_index_list [, tbl_index_list] ... IN key_c -
Replication Commands
START, STOP, and etc... for MASTER and SLAVE servers. -
EXECUTE statement
Syntax EXECUTE stmt_name [USING @var_name [, @var_name] ...]Description... -
FLUSH commands
Commands to reset (flush) various caches in MariaDB/MySQL. -
KILL [CONNECTION | QUERY]
Syntax KILL [HARD | SOFT] [CONNECTION | QUERY] [thread_id | USER user_name]... -
LOAD INDEX
Syntax LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list] ... tbl_i... -
Plugins
Plugin commands. -
PURGE logs
Syntax PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime... -
SET
Syntax SET variable_assignment [, variable_assignment] ... variable_assignment: user_ -
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
Syntax: SET GLOBAL sql_slave_skip_counter = NDescription: This statement sk... -
SET SQL_LOG_BIN
Syntax: SET sql_log_bin = {0|1}Description: Disables or enables binary logg... -
SHOW
Articles on the various SHOW commands. -
Table commands
Articles about creating, modifying, and maintaining tables in MariaDB. -
System Tables
System Tables -
USE
Syntax: USE db_nameDescription: The 'USE db_name' statement tells MariaDB t... -
DESCRIBE
Syntax: {DESCRIBE | DESC} tbl_name [col_name | wild]Description: DESCRIBE p... -
EXPLAIN
Syntax: EXPLAIN tbl_nameOr: EXPLAIN [EXTENDED | PARTITIONS] SELECT select_o... -
HELP command
Syntax MariaDB [(none)]> HELP search_stringDescription The HELP command can... -
SHOW EXPLAIN
This is a preliminary documentation for SHOW EXPLAIN feature. The code The ...
