SQL DELETE

DROP DATABASE

Examples

-- 单表删除: 删除一条记录
DELETE FROM student
WHERE studentno = 'S004';
		    

-- 多表删除: 删除员工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;