建立存储过程
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("要删除的库名");
标签:cur,删除,表中,stmt,done,mysql,table,tb,declare From: https://www.cnblogs.com/ThisYbc/p/16931496.html