SQL commands for administering MariaDB.
-
BINLOG
Syntax: BINLOG 'str' Description: BINLOG is an in... -
CACHE INDEX
Syntax <<code>> CACHE INDEX ... -
Replication Commands
START, STOP, and etc... for MASTER and SLAVE servers. -
EXECUTE statement
Syntax EXECUTE stmt_name [USING @var_name [, @... -
FLUSH commands
Commands to reset (flush) various caches in MariaDB/MySQL. -
KILL [CONNECTION | QUERY]
Syntax KILL [HARD | SOFT] [CONNECTION | QUERY] [th... -
LOAD INDEX
Syntax LOAD INDEX INTO CACHE tbl_index_list [, t... -
Plugins
Plugin commands. -
PURGE logs
Syntax PURGE { BINARY | MASTER } LOGS { TO 'lo... -
SET
Syntax <<code>> SET variable_assignment [, variabl... -
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
Syntax: SET GLOBAL sql_slave_skip_counter = N Desc... -
SET SQL_LOG_BIN
Syntax: SET sql_log_bin = {0|1} Description: Disab... -
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_name Description: The 'USE db_name'... -
DESCRIBE
Syntax: {DESCRIBE | DESC} tbl_name [col_name | wil... -
EXPLAIN
Syntax: EXPLAIN tbl_name Or: EXPLAIN [EXTENDED | P... -
HELP command
Syntax MariaDB [(none)]> HELP search_string Descri...