56,683
社区成员
发帖
与我相关
我的任务
分享
DROP PROCEDURE IF EXISTS sp_alter_db_charset;
CREATE PROCEDURE `sp_alter_db_charset`(in i_dbname varchar(50))
begin
declare v_i int default 0;
declare v_tbname varchar(100);
declare cur_test cursor for select table_name from information_schema.tables where table_schema=i_dbname;
declare continue handler for not found set v_i=1;
open cur_test;
fetch cur_test into v_tbname;
while v_i=0 do
set @str=concat('alter table ',v_tbname,' charset gbk');
prepare stmt1 from @str;
execute stmt1;
deallocate prepare stmt1;
fetch cur_test into v_tbname;
end while;
close cur_test;
end;
call sp_alter_db_charset('库名');