sql Delete的Where套用select

方式一：

登录后复制

delete from table where id in (select user_id from table2)

• 1.

方式二：

登录后复制

delete a from a,(select id from XXXX where XXX) b where a.id = b.id

• 1.

 

作者：꧁执笔小白꧂

原创作者: u_16822845 转载于: https://blog.51cto.com/u_16822845/11676095