psmysql_mysql存储过程（ps:用法自己看：）

delimiter //

drop procedure if exists operate_tables //

create procedure operate_tables (in db_name varchar(100), in operate varchar(100))

begin

declare finish int default 0;

declare tab_name varchar(100);

-- 把select 出来的数据放到游标中

declare cur_tables cursor for select table_name from information_schema.tables

where table_schema &＃61; db_name and table_type &＃61; &＃39;base table&＃39;;

-- 若没有数据返回,程序继续,并将变量finish设为1

declare continue handler for not found set finish &＃61; 1;

open cur_tables;

exce_loop:loop

if finish &＃61; 1 then

leave exce_loop;

end if;

fetch cur_tables into tab_name;

set &＃64;str &＃61; concat(operate , &＃39; &＃39;, db_name, &＃39;.&＃39;, tab_name);

prepare stmt from &＃64;str; -- 预定义sql

execute stmt; -- (如果sql有参数的话, USING xxx,xxx); 这里USING的只能是会话变量

deallocate prepare stmt; -- 释放连接

end loop;

close cur_tables;

end; //

delimiter ;

-- call operate_tables(&＃39;test&＃39;, &＃39;truncate&＃39;);

-- call operate_tables(&＃39;test&＃39;, &＃39;drop table&＃39;);