mysql以另一条sql为条件判断批量删除的语句!

delete from topline WHERE id in(select id from (SELECT id from topline WHERE newsNumber ='55' ) as t)

posted @ 2017-01-25 09:17  G善源  阅读(150)  评论(0编辑  收藏  举报