Administrative SQL Statements
SQL statements for administering MariaDB.
-
Table Statements
Documentation on creating, altering, analyzing and maintaining tables. -
ANALYZE and EXPLAIN Statements
Articles on the ANALYZE and EXPLAIN statements -
BACKUP Commands
Commands used by backup tools. -
FLUSH Commands
Commands to flush or reset various caches in MariaDB. -
Replication Commands
List of replication-related commands. -
Plugin SQL Statements
List of SQL statements related to plugins. -
SET Commands
The SET commands -
SHOW
Articles on the various SHOW commands. -
System Tables
-
BINLOG
Internal statement generated by mariadb-binlog. -
PURGE BINARY LOGS
PURGE BINARY LOGS removes all binary logs from the server, prior to the provided date or log file. -
CACHE INDEX
Caches MyISAM or Aria indexes -
DESCRIBE
Information about columns in a table. -
EXECUTE Statement
Executes a previously PREPAREd statement -
HELP Command
The HELP command will retrieve syntax and help within the mariadb client. -
KILL [CONNECTION | QUERY]
Kill connection by query or thread id. -
LOAD INDEX
Loads one or more indexes from one or more MyISAM/Aria tables into a key buffer. -
RESET
Overall description of the different RESET commands -
SHUTDOWN
Shuts down the server. -
USE [DATABASE]
Set the current default database.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
