方式 一:delete from where
1.单表的删除:
2.多表的删除:
方式二:truncate table:清空表
truncate删除不能回滚,delete删除可以回滚
*/
#删除语句
/*
方式 一:delete from where
1.单表的删除:
2.多表的删除:
方式二:truncate table;
truncate删除不能回滚,delete删除可以回滚
*/
#一。单表的删除
#案例一:删除手机号一9结尾的女神信息
DELETE FROM beauty WHERE phone LIKE "%9";
#二。多表的删除
#案例一:删除张无忌女朋友的信息
DELETE b FROM beauty AS b
INNER JOIN boys AS bo ON b.boyfriend_id = bo.id
WHERE bo.boyName = '张无忌';
#案例二:删除黄晓明的信息以及他女朋友的信息
DELETE bo,b FROM boys AS bo
INNER JOIN beauty AS b ON bo.id = b.boyfriend_id
WHERE boyName = '黄晓明';
#三。truncate删除所有数据,即清空表
TRUNCATE boys;