W3cubDocs

/MariaDB

SQL Statements

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
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.

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