1.语法:
(1)单行删除 delete from 表明 where 判断条件(删除一行)
(2)多行删除 delete 别名1,别名2,… from 表名1 inner(left/right) join 表名2
on 连接条件
where 判断条件
2.试题:删除张无忌女友的信息
DELETE bo,b
FROM boys bo
INNER JOIN beauty b
ON bo.id = b.`boyfriend_id`
WHERE bo.`boyName`='张无忌';
1.语法:
(1)单行删除 delete from 表明 where 判断条件(删除一行)
(2)多行删除 delete 别名1,别名2,… from 表名1 inner(left/right) join 表名2
on 连接条件
where 判断条件
2.试题:删除张无忌女友的信息
DELETE bo,b
FROM boys bo
INNER JOIN beauty b
ON bo.id = b.`boyfriend_id`
WHERE bo.`boyName`='张无忌';