Changing & Deleting Data

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

Complete guide to deleting data in MariaDB. Complete DELETE syntax with WHERE filtering, JOIN operations, CTEs, and safety considerations for production use.

HIGH_PRIORITY and LOW_PRIORITY

Control locking priority for table access. These modifiers determine whether read or write operations take precedence when multiple threads access a table.

REPLACE

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.

REPLACE...RETURNING

Replace rows and retrieve the results immediately. This extension returns the values of the replaced or inserted rows in the same operation.

UPDATE

Complete UPDATE statement guide for MariaDB. Complete syntax reference with WHERE conditions, JOIN operations, CTEs, and multi-table updates for production use.