Re: How To Delete Older Records In Chunks

[Shobhit Srivastava]

Hey Rick,

Thanks for your response!

The block that I am using is from the same Web Page that you have shared.
Unfortunately, the block is not executing.

----------I have taken and modified below block from your URL----------
@a = 0
LOOP
DELETE FROM tbl
WHERE id BETWEEN @a AND @a+999
AND ts < DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
SET @a = @a + 1000
sleep 1 -- be a nice guy
UNTIL end of table
-----------------------------------------------------------------------