什么不能用IN和?EXISTS?
你是说在DELETE语句中不能用这两个关键字吗?
呵呵,如果按你上面的语法写的话,删除的可是两个表的内容呀
delete spcselecttemp from spcselecttemp a,spccharact b where a.fid=b.charactid-==>>
delete spcselecttemp from spcselecttemp where fid in (select charactid from spccharact);
or:
delete spcselecttemp from spcselecttemp where fid = (select charactid from spccharact);
你是说在DELETE语句中不能用这两个关键字吗?
呵呵,如果按你上面的语法写的话,删除的可是两个表的内容呀
delete spcselecttemp from spcselecttemp a,spccharact b where a.fid=b.charactid-==>>
delete spcselecttemp from spcselecttemp where fid in (select charactid from spccharact);
or:
delete spcselecttemp from spcselecttemp where fid = (select charactid from spccharact);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货