mysql - 执行sql删除查询foreach user_id

Question

是否可以对表中的每个user_id执行sql删除查询？我可以通过SELECT user_id FROMusers获取所有user_id然后我可以使用

删除除最后一个之外的所有原始数据

DELETE FROM accounts
WHERE id IN (select * from (SELECT id 
FROM   accounts 
WHERE  user_id = 150192618395339835 
       AND site = 'https://www.paypal.com' 
       AND time_added < (SELECT Max(time_added) 
                         FROM   accounts 
                         WHERE  user_id = 150192618395339835 
                                AND site = 'https://www.paypal.com') 
ORDER  BY time_added ASC) as t)

如何传递所有 user_id 来删除查询？

Answer 1

尝试使用

WHERE user_id in (SELECT u.user_id FROM users u) 

以及所有查询:

DELETE FROM accounts
WHERE id IN (select * from (SELECT id 
FROM   accounts 
WHERE  user_id in (SELECT u.user_id FROM users u) 
       AND site = 'https://www.paypal.com' 
       AND time_added < (SELECT Max(time_added) 
                         FROM   accounts 
                         WHERE  user_id = 150192618395339835 
                                AND site = 'https://www.paypal.com') 
ORDER  BY time_added ASC) as t)