常用存储过程
1、修改Database中所有表的所有字段的编码格式(mysql)
delimiter $$
CREATE PROCEDURE Test ()
begin
DECLARE cnt VARCHAR(100);
DECLARE i int;
set i = 0;
while i < 77 do
select table_name into @cnt from information_schema.`TABLES` where TABLE_SCHEMA = 'redmine' limit i,1;
set @sql = concat("alter table ", @cnt, " convert to character set utf8mb4");
prepare stmt from @sql;
execute stmt;
deallocate prepare stmt;
set i = i + 1;
end while;
end$$
delimiter ;
call Test ;
参考:https://blog.csdn.net/LUNG108/article/details/78285054