mysql批量修改字符集
来源:互联网 发布:网络协议实验报告 编辑:程序博客网 时间:2024/05/22 13:36
改所有表的字符集:
这个可以运行:
/*更改discuz数据库中每个表的字符集为utf8,校对规则为utf8_bin */
CALL qifei();
DROP PROCEDURE IF EXISTS qifei;
CREATE PROCEDURE qifei()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a VARCHAR(80);
DECLARE rs CURSOR FOR SELECT t.TABLE_NAME AS lbg FROM information_schema.TABLES t where t.TABLE_SCHEMA='jshoper3';
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
open rs;
REPEAT
FETCH rs INTO a;
SET @s = CONCAT(' ALTER TABLE `',a,'` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin');
SELECT @s;
PREPARE stmt FROM @s;
EXECUTE stmt;
UNTIL done END REPEAT;
CLOSE rs;
END
这个可以运行:
/*更改discuz数据库中每个表的字符集为utf8,校对规则为utf8_bin */
CALL qifei();
DROP PROCEDURE IF EXISTS qifei;
CREATE PROCEDURE qifei()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a VARCHAR(80);
DECLARE rs CURSOR FOR SELECT t.TABLE_NAME AS lbg FROM information_schema.TABLES t where t.TABLE_SCHEMA='jshoper3';
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
open rs;
REPEAT
FETCH rs INTO a;
SET @s = CONCAT(' ALTER TABLE `',a,'` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin');
SELECT @s;
PREPARE stmt FROM @s;
EXECUTE stmt;
UNTIL done END REPEAT;
CLOSE rs;
END
0 0
- mysql批量修改字符集
- 修改MySQL的字符集
- 修改mysql字符集
- mysql 如何修改字符集
- MySQL字符集修改命令
- MySQL字符集修改命令
- 修改mysql字符集编码
- 修改mysql字符集
- 查看修改MySQL字符集
- MYSQL字符集 怎么修改
- Mysql 修改字符集
- MySQL修改默认字符集
- MySQL修改默认字符集
- 完全修改mysql字符集
- Mysql 修改字符集
- MySQL修改默认字符集
- 修改mysql默认字符集
- [Mysql]修改默认字符集
- 网络流题目集锦
- spingIoc注解方式之通常运用
- 欢迎使用CSDN-markdown编辑器
- 滴,学生卡||终于自学完了C++
- [LeetCode]235. Lowest Common Ancestor of a Binary Search Tree
- mysql批量修改字符集
- 计算几何题目集锦
- 开篇--2017年计划
- 云服务器Window Server 2012R系统安装MySQL
- 38-1-2
- ssm整合中出现illegalargumentexception、NosuchbeansException解决
- PLSQL Trigger :OLD :NEW
- 6.4响应首部字段
- 博弈题目集锦