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. |
© 2019 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/