存储过程批量删除数据

使用存储过程

drop PROCEDURE if exists usp_delete_bulk_table; 
create PROCEDURE usp_delete_bulk_table()
begin
declare i int DEFAULT 1;
 WHILE i>0 DO
   DELETE FROM t_log WHERE ORGANIZATIONID=0 LIMIT 1000;
   if ROW_COUNT()<1000 then
        set i=0 ;
      end IF;
   select sleep(1);      
 END WHILE;
end;
call usp_delete_bulk_table();