> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements.md).

# SQL Statements

{% columns %}
{% column %}
{% content-ref url="/pages/MNFYOPjrF4zmOtd6hJ3z" %}
[Data Definition (DDL)](/docs/server/reference/sql-statements/data-definition.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn data definition language (DDL) statements in MariaDB Server. This section covers SQL commands for creating, altering, and dropping databases, tables, indexes, and other schema objects.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/0oITHV4r9nOgqZ6txSYr" %}
[Data Manipulation (DML)](/docs/server/reference/sql-statements/data-manipulation.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn data manipulation language (DML) statements in MariaDB Server. This section covers SQL commands for inserting, updating, deleting, and selecting data within your databases.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/HB51bux5jpgbLhyRORMV" %}
[Account Management](/docs/server/reference/sql-statements/account-management-sql-statements.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn account management SQL statements for MariaDB Server. This section covers commands like CREATE USER, GRANT, and REVOKE to securely manage user access and privileges within your database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/POKzOwZFZUYXFxh6fKqi" %}
[Administrative Statements](/docs/server/reference/sql-statements/administrative-sql-statements.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore administrative SQL statements for MariaDB Server. This section covers commands for server management, maintenance, and diagnostics, including BINLOG, KILL, SHUTDOWN, and SHOW.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/IeiUsmONnNz0aYaTl1zt" %}
[SQL Functions](/docs/server/reference/sql-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover functions and procedures in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/v2w6lxSzWJfR4gMkBq38" %}
[Prepared Statements](/docs/server/reference/sql-statements/prepared-statements.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about prepared statements in MariaDB Server. This section details how to use them for efficient and secure execution of repetitive SQL queries, preventing SQL injection vulnerabilities.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/La1NjeBlzgtxFZe4NENp" %}
[Programmatic & Compound Statements](/docs/server/reference/sql-statements/programmatic-compound-statements.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore programmatic compound statements in MariaDB Server. This section covers BEGIN...END blocks, loops, and conditional logic for writing complex stored routines and event definitions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/XqqPWhqXzauZN9IjpmeC" %}
[Stored Routines](/docs/server/server-usage/stored-routines.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Automate tasks in MariaDB Server with stored routines. Learn to create and manage stored procedures and functions for enhanced database efficiency and code reusability.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/RhdkGCEGZCQB2GO58hiI" %}
[Table Statements](/docs/server/reference/sql-statements/table-statements.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about table-related SQL statements in MariaDB Server. This section covers commands for creating, altering, dropping, and manipulating tables, essential for managing your database schema.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/OpqEC5BZeYBwqLw1BdcJ" %}
[Transactions](/docs/server/reference/sql-statements/transactions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about transactions in MariaDB Server. This section covers SQL statements for managing atomic operations (START TRANSACTION, COMMIT, ROLLBACK), ensuring data integrity and consistency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/MoQPN8H5TbrXrKrGLvjU" %}
[Comment Syntax](/docs/server/reference/sql-statements/comment-syntax.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete SQL comment syntax: single-line # and -- (space required), multi-line /\* */ blocks, MySQL /*!##### \*/ and MariaDB /\*M!##### \*/ executable comments.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/eSw1uojk2JMySQ16BvPR" %}
[HELP Command](/docs/server/reference/sql-statements/administrative-sql-statements/help-command.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Displays help information from the server's help tables. Useful for looking up SQL syntax and command descriptions directly from the client.
{% endcolumn %}
{% endcolumns %}