LOOP to delet by block.

[Alexandre Salomé]

Hello,

I am trying create a MYSQL script that delete many rows of a big table.

I do not know why this doesn´t works
I am trying command of mysql oficial guide and other web examples..



Please, help me:


---------
SELECT COUNT(id) FROM traccaroficial.tc_events WHERE serverTime < DATE_ADD(NOW(), INTERVAL -30 DAY) INTO @Quantidade_Total_De_Registro ;




BEGIN

if ( @Quantidade_Total_De_Registro >0 ) then

DELETE FROM traccaroficial.tc_events WHERE serverTime < DATE_ADD(NOW(), INTERVAL -30 DAY) limit 1000

@Quantidade_Total_De_Registro = @Quantidade_Total_De_Registro - 1000;

else
LEAVE sp

END if

END
------




the error is:

sql syntax near ps:begin