MariaDB: DELETE


-- Single Table

TRUNCATE [TABLE] tbl_name
  [WAIT n | NOWAIT]

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    FROM tbl_name [PARTITION (partition_list)]
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]
    [RETURNING select_expr
      [, select_expr ...]]

-- Multi Table

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    tbl_name[.*] [, tbl_name[.*]] ...
    FROM table_references
    [WHERE where_condition]

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    FROM tbl_name[.*] [, tbl_name[.*]] ...
    USING table_references
    [WHERE where_condition]

-- Examples

DELETE FROM page_hit ORDER BY timestamp LIMIT 1000000;

DELETE FROM t RETURNING f1;

DELETE post FROM blog INNER JOIN post WHERE blog.id = post.blog_id;