DROP PROCEDURE IF EXISTS truncate_chapter_order
;
DELIMITER ;;
CREATE PROCEDURE truncate_chapter_order
()
BEGIN
DECLARE n INT;
DECLARE sql_text VARCHAR(2000);
SET n = 511;
WHILE n >= 0 DO
SET sql_text = concat(‘truncate table 222chapter_orders’,n);
SELECT sql_text;
SET @sql_text=sql_text;
PREPARE stmt FROM @sql_text;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET n = n – 1;
END WHILE;
END
;;
DELIMITER ;
CALL truncate_chapter_order();