如题,
删除表table1中name项和table2中name项相同的,并且id项等于1的所有数据!
我用过
delete table1.*
from table1 join table2
on table1.name=table2.name and table1.id=1总是报错
删除表table1中name项和table2中name项相同的,并且id项等于1的所有数据!
我用过
delete table1.*
from table1 join table2
on table1.name=table2.name and table1.id=1总是报错
from table1 join table2
on table1.name=table2.name and table1.id=1
where exists(select 1 from table2 as b where a.name=b.name and a.id=1)
from table1,table2
where table1.name=table2.name and table1.id=1