修改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;

原文地址:https://www.cnblogs.com/1659666966/p/13392064.html