MySQL uses stored procedures to clear all table data from the database, saving data structures

BEGIN
DECLARE strclear VARCHAR (256);
DECLARE done INT DEFAULT 0;
#定义游标
DECLARE curone CURSOR for select concat (' TRUNCATE TABLE ', table_name, '; ') from INFORMATION_SCHEMA. TABLES where table_schema= ' test ';
#绑定控制变量到游标, the end of the cursor loop is automatically converted to true
DECLARE CONTINUE HANDLER for don't FOUND SET done = 1;
#打开游标
OPEN Curone;
REPEAT
FETCH Curone into Strclear;
#SELECT strclear;
#动态执行SQL语句
SET @mysql = strclear;
PREPARE stmt from @mysql;
EXECUTE stmt;
Deallocate PREPARE stmt;

UNTIL done = 1 END REPEAT;

#关闭游标
CLOSE Curone;
END

MySQL uses stored procedures to clear all table data from the database, saving data structures