3
Changing & Deleting Data
-
DELETE
Delete rows from one or more tables. -
HIGH_PRIORITY and LOW_PRIORITY
Modifying statement priority in storage engines supporting table-level locks. -
IGNORE
Suppress errors while trying to violate a UNIQUE constraint. -
REPLACE
Equivalent to DELETE + INSERT, or just an INSERT if no rows are returned. -
REPLACE...RETURNING
Returns a resultset of the replaced rows. -
TRUNCATE TABLE
DROP and re-CREATE a table. -
UPDATE
Modify rows in one or more tables.
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.
