,在一个表中有三个联合主键 provinceid,cityid,townid,现在要删除多条记录!用in这样写不行,能帮我看看问题在哪吗?谢谢!
delete from town t where t.provinceid,t.cityid,t.townid in("'1',2'','3'","'4','5','6'")
delete from town t where t.provinceid,t.cityid,t.townid in("'1',2'','3'","'4','5','6'")
试试这个sql
delete from town t where (t.provinceid='1'AND t.cityid='2'AND t.townid='3') OR (t.provinceid='4'AND t.cityid='5'AND t.townid='6')跟你想的的结果一样吗