Complete list of SQL statements for data definition, data manipulation, etc.
| Title | Description |
|---|---|
| Account Management SQL Commands | CREATE/DROP USER, GRANT, REVOKE, SET PASSWORD etc. |
| Administrative SQL Statements | SQL statements for setting, flushing and displaying server variables and resources. |
| Data Definition | SQL commands for defining data, such as ALTER, CREATE, DROP, RENAME etc. |
| Data Manipulation | SQL commands for querying and manipulating data, such as SELECT, UPDATE, DELETE etc. |
| Prepared Statements | Prepared statements from any client using the text based prepared statement interface. |
| Programmatic & Compound Statements | Compound SQL statements for stored routines and in general. |
| Stored Routine Statements | SQL statements related to creating and using stored routines. |
| Table Statements | Documentation on Creating, Altering, Analyzing and Maintaining Tables. |
| Transactions | Sequence of statements that are either completely successful, or have no effect on any schemas |
| HELP Command | The HELP command will retrieve syntax and help within the mysql client. |
| Comment Syntax | Comment syntax and style |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/sql-statements/