sqlserver where in 在 mysql

delete from t where id in(select * from ((select idfrom twhere id <5) tmp);  

主句(select * from (从句 temp)

sql的 where in 删除  要更改为  //

in(

select * from ((select idfrom twhere id <5) tmp

)


posted @ 2018-08-10 12:02  enych  阅读(311)  评论(0编辑  收藏  举报