Re: How to delete millions of record in a loop

[Phillip Ward]

Redefine the statement delimiter so that MySql processes the entire procedure as a single unit.
http://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html

delimiter //

create procedure . . . 
. . . 
end;
//

delimiter ;

However, instead of all that ,can you not simply "Truncate" the table?
http://dev.mysql.com/doc/refman/5.7/en/truncate-table.html

Regards, Phill W.