MySQL_Shell_清空数据库表中的数据

今天博主写了一个删除数据库数据的存储过程，如下所示：

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;