MySQL Delete bulk Delete table

BEGIN
declare done int default false;
DECLARE TABLE_NAME_STR VARCHAR (64);
declare table_rows_mum int;
DECLARE sqltext VARCHAR (2000); # Splicing SQL string
DECLARE auto_sql_str VARCHAR (2000);

Declare _cur cursor FOR select table_name,table_rows from Information_schema. ' TABLES ' where table_schema = ' tzgame ' and TA Ble_rows = 0 ORDER BY table_rows Desc; #主订单查询
Declare continue HANDLER for don't found set done = true;
OPEN _cur;
FETCH _cur into Table_name_str,table_rows_mum;
while (not doing) do
Set sqltext:= CONCAT (' TRUNCATE ', table_name_str, '; ');
Set auto_sql_str:= CONCAT (' ALTER TABLE ', table_name_str, ' auto_increment = 1; ‘);

PREPARE STMT from SQLText;
EXECUTE STMT;

PREPARE STMT from Auto_sql_str;
EXECUTE STMT;

Fetch _cur into table_name_str,table_rows_mum;
End while;
CLOSE _cur;
End

MySQL Delete bulk Delete table