mysql删除所有表中数据

建立存储过程

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 and table_type = "BASE TABLE";
    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("要删除的库名");