# Data Manipulation (DML)

- [Changing & Deleting Data](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data.md): Learn to change and delete data in MariaDB Server. This section covers UPDATE and DELETE SQL statements, enabling you to modify existing records and remove unwanted information efficiently.
- [DELETE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/delete.md)
- [HIGH\_PRIORITY and LOW\_PRIORITY](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/high_priority-and-low_priority.md)
- [REPLACE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replace.md)
- [REPLACE...RETURNING](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replacereturning.md)
- [UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md)
- [Inserting & Loading Data](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data.md): Learn to insert and load data into MariaDB Server. This section covers INSERT and LOAD DATA SQL statements, enabling you to efficiently add new records to your databases.
- [Concurrent Inserts](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/concurrent-inserts.md)
- [IGNORE](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/ignore.md)
- [INSERT - Default & Duplicate Values](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-default-duplicate-values.md)
- [INSERT DELAYED](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-delayed.md)
- [INSERT IGNORE](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-ignore.md)
- [INSERT ON DUPLICATE KEY UPDATE](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-on-duplicate-key-update.md)
- [INSERT SELECT](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-select.md)
- [INSERT](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert.md)
- [INSERT...RETURNING](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insertreturning.md)
- [LOAD Data into Tables or Index](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index.md): Learn to load data into MariaDB tables or indexes using LOAD DATA. This section details efficient methods for bulk importing data from external files, optimizing for large datasets.
- [LOAD DATA INFILE](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index/load-data-infile.md)
- [LOAD INDEX](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index/load-index.md)
- [LOAD XML](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index/load-xml.md)
- [Selecting Data](/docs/server/reference/sql-statements/data-manipulation/selecting-data.md): Learn to select data in MariaDB Server using SQL. This section covers various SELECT statement clauses, including WHERE, GROUP BY, and ORDER BY, to retrieve and filter your data effectively.
- [DUAL](/docs/server/reference/sql-statements/data-manipulation/selecting-data/dual.md)
- [FOR UPDATE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/for-update.md)
- [GROUP BY](/docs/server/reference/sql-statements/data-manipulation/selecting-data/group-by.md)
- [LIMIT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/limit.md)
- [LOCK IN SHARE MODE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/lock-in-share-mode.md)
- [Optimizer Hints](/docs/server/reference/sql-statements/data-manipulation/selecting-data/optimizer-hints.md)
- [ORDER BY](/docs/server/reference/sql-statements/data-manipulation/selecting-data/order-by.md)
- [PROCEDURE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/procedure.md)
- [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md)
- [SELECT INTO DUMPFILE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-into-dumpfile.md)
- [SELECT INTO OUTFILE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-into-outfile.md)
- [SELECT ... OFFSET ... FETCH](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-offset-fetch.md)
- [SELECT WITH ROLLUP](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-with-rollup.md)
- [Common Table Expressions (CTE)](/docs/server/reference/sql-statements/data-manipulation/selecting-data/common-table-expressions.md): Learn about Common Table Expressions (CTEs) in MariaDB Server. This section explains how to use CTEs for complex, readable, and reusable subqueries, simplifying data selection and manipulation.
- [WITH](/docs/server/reference/sql-statements/data-manipulation/selecting-data/common-table-expressions/with.md)
- [Non-Recursive Common Table Expressions Overview](/docs/server/reference/sql-statements/data-manipulation/selecting-data/common-table-expressions/non-recursive-common-table-expressions-overview.md)
- [Recursive Common Table Expressions Overview](/docs/server/reference/sql-statements/data-manipulation/selecting-data/common-table-expressions/recursive-common-table-expressions-overview.md)
- [Joins & Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries.md): Learn about joins and subqueries in MariaDB Server. This section details how to combine data from multiple tables and nest queries to perform complex data retrieval operations efficiently.
- [EXCEPT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/except.md)
- [INTERSECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/intersect.md)
- [MINUS](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/minus.md)
- [Precedence Control in Table Operations](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/precedence-control-in-table-operations.md)
- [UNION](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/union.md)
- [Joins](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins.md): Learn about SQL joins. This section details various join types (INNER, LEFT, RIGHT, FULL) to combine rows from two or more tables based on related columns, enabling complex data retrieval.
- [JOIN Syntax](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins/join-syntax.md)
- [More Advanced Joins](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins/more-advanced-joins.md)
- [Comma vs JOIN](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins/comma-vs-join.md)
- [Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries.md): Learn about subqueries in MariaDB Server. This section details how to use nested queries to perform complex data retrieval, filtering, and manipulation operations within a single SQL statement.
- [Subqueries and ALL](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-all.md)
- [Subqueries and ANY](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-any.md)
- [Subqueries and EXISTS](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-exists.md)
- [Subqueries and JOINs](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-joins.md)
- [Subqueries in a FROM Clause (Derived Tables)](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-in-a-from-clause-derived-tables.md)
- [Row Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-row-subqueries.md)
- [Scalar Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-scalar-subqueries.md)
- [Subquery Limitations](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subquery-limitations.md)
