修改Mysql 数据库以及表字符集

【修改数据库】

alter database ExpertExaminationDB character set utf8;

【修改数据表】(生成sql语句,再执行)

SELECT
CONCAT( 'ALTER TABLE ',TABLE_NAME,' CONVERT TO CHARACTER SET utf8;')
FROM
information_schema.`TABLES`
WHERE
TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME;

posted @ 2020-07-28 16:50  chendashuo  阅读(234)  评论(0编辑  收藏  举报