Administrative SQL Statements
SQL statements for administering MariaDB.
| Title | Description |
|---|---|
| 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 | Generated by mysqlbinlog |
| 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 mysql 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 | 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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/administrative-sql-statements/