delete * from a where Fdi_no='a1' and Fdi_no='b1';好像不行
delete * from a where Fdi_no='a1' or Fdi_no='b1';好像不行
delete * from a where Fdi_no in (a1,b1);好像也不行
还有什么方法,上面我有写错的地方吗?
delete * from a where Fdi_no='a1' or Fdi_no='b1';好像不行
delete * from a where Fdi_no in (a1,b1);好像也不行
还有什么方法,上面我有写错的地方吗?
delete from a where Fdi_no='a1' or Fdi_no='b1'
delete from a where Fdi_no in (a1,b1)
或者你的列表是select fdi_no where 条件delete from a where Fdi_no in (select fdi_no where 条件)