MySql多表关联删除记录示例
发布：智码IT网 阅读：
需求：
现有学生表student和班级表class，需要删除student表中班级为二班的记录，结构如图所示：
-- 语法一：使用join连接
DELETE
student
FROM
student
LEFT JOIN class ON student.ClassID = class.id
WHERE
class.ClassName = '二班'
-- 语法二：多表查询
DELETE
student
FROM
student,
class
WHERE
student.ClassID = class.id
AND class.ClassName = '二班'
-- 语法三：使用using关键字
DELETE
FROM
student
USING
student,
class
WHERE
student.ClassID = class.id
AND class.ClassName = '二班'
上一篇：没有了
下一篇：没有了