create procedure all_do()
begin
declare done int default 0;
declare v_sql varchar(1500);
declare tname varchar(50);
declare cur1 cursor for select table_name from information_schema.`TABLES` where table_schema='unionshop' and table_type='BASE TABLE' and table_name like 'new_%' ;
declare continue handler for sqlstate '02000' set done=1;
open cur1;
repeat
fetch cur1 into tname ;
if not done then
set v_sql=concat(' truncate table ',tname,' ; ');
set @v_sql=v_sql;
prepare stmt from @v_sql;
EXECUTE stmt ;
deallocate prepare stmt;
end if;
until done
end repeat;
close cur1;
end
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8797129/viewspace-591376/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8797129/viewspace-591376/