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("【**需要清理的数据库名称**】"); drop procedure if exists del_all_tb;
这篇文档对您是否有帮助?