SQL DELETE

DROP DATABASE

Syntax

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
  FROM tbl_name [PARTITION (partition_list)]
  [FOR PORTION OF period FROM expr1 TO expr2]
  [AS alias]                    -- from MariaDB 11.6
  [WHERE where_condition]
  [ORDER BY ...]
  [LIMIT row_count]
  [RETURNING select_expr
    [, select_expr ...]]
		    

Examples

-- 单表删除: 删除一条记录
DELETE FROM employees
WHERE employee_id = 54232;
		    

-- 多表删除: 删除员工ID为76196的信息及其所在部门信息
DELETE e, o
FROM employees AS e
INNER JOIN offices AS o ON e.`office_id`=o.`office_id`
WHERE e.`employee_id` = 76196;