今天博主写了一个删除数据库数据的存储过程,如下所示:
drop procedure if exists del_all_tb;
delimiter $$
create procedure del_all_tb(db char(20))
begin
declare done int default 0;
declare tb char(100);
declare cur cursor for select table_name from infoRmation_schema.tables where table_schema = db;
declare continue handler for not found set done = 1;
open cur;
repeat
fetch cur into tb;
set @sql := concat("truncate ", tb, ";");
prepare stmt from @sql;
execute stmt;
deallocate prepare stmt;
until done end repeat;
close cur;
end $$
delimiter ;
call del_all_tb("数据库名");
drop procedure if exists del_all_tb;