怎样改写delete from select * from table
delete from select * from table
这样写无法执行,请问怎样改写.
[解决办法]
delete table where ?? not in (select ?? from table))
delete table where ?? in (select ?? from table))
[解决办法]
delete a from a, b where ???
[解决办法]
delete from a where ?