delete
FROM
cd_message_context
WHERE
EXISTS ( SELECT 1 FROM es_user eu WHERE cd_message_context.RECEIVER = eu.ESUS_LOGIN_NAME AND eu.ESUS_SUBSTR1 NOT IN ( "SUPPLIER" ))
AND cd_message_context.TITLE LIKE "%未报到%" limit 50000;
delete删除时,限制条件在另一个表,且限制删除条数
最新推荐文章于 2022-11-11 16:17:57 发布