批量删除sql语句

SET @I = 148;
SELECT CONCAT("DELETE FROM supplier_change_log WHERE old_supplier_id=4194 AND id>=",@I," AND id<",@I:=@I+2000,";SELECT SLEEP(0.2);") FROM supplier_change_log LIMIT 1205;

posted @ 2019-09-05 21:23  Doyourself!  阅读(8367)  评论(0编辑  收藏  举报