多表删除

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;//失败


失败原因是笛卡尔乘积，懒的研究先这样了