insert into test2 values('1','lwj'),('2','ly'),('3','yjp');
insert into test1 values('1','ybx'),('2','wc'),('3','yjp');
delete test1 from test1,test2 where test1.name=test2.name;//成功
DELETE FROM t1 USING t1,t2 WHERE t1.id=t2.id//成功
delete test1,test2 from test1,test2 where test1.name=test2.name;//成功
delete test1 from test1,test2 where test1.name<>test2.name;//失败
失败原因是笛卡尔乘积,懒的研究先这样了
多表删除
最新推荐文章于 2023-03-28 11:10:14 发布