> 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/data-manipulation/changing-deleting-data.md).

# Changing & Deleting Data

{% columns %}
{% column %}
{% content-ref url="/pages/m5441E3tn6YdrYsJpkgW" %}
[DELETE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/delete.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to deleting data in MariaDB. Complete DELETE syntax with WHERE filtering, JOIN operations, CTEs, and safety considerations for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/DlsXVqNxPNuCo53ISbNh" %}
[HIGH\_PRIORITY and LOW\_PRIORITY](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/high_priority-and-low_priority.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Control locking priority for table access. These modifiers determine whether read or write operations take precedence when multiple threads access a table.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/e9RfzI3eFLmlGIJAe29G" %}
[REPLACE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replace.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Insert or replace rows based on unique keys. This statement acts like INSERT, but if a duplicate key exists, it deletes the old row and inserts the new one.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QX2vesq1ukREYopj4T0Z" %}
[REPLACE...RETURNING](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replacereturning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Replace rows and retrieve the results immediately. This extension returns the values of the replaced or inserted rows in the same operation.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ymzU1J0bSwFzEOp6Y0a8" %}
[UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete UPDATE statement guide for MariaDB. Complete syntax reference with WHERE conditions, JOIN operations, CTEs, and multi-table updates for production use.
{% endcolumn %}
{% endcolumns %}