mysql数据表改字符集_修改mysql数据表字符集

修改数据库：

查看当前数据库字符集

show VARIABLES like 'character%';

修改数据库字符集

alter database 数据库名 character set utf8;

ps:修改完数据库字符集，需要重启mysql数据库。

修改表

单条SQL：

ALTER TABLE `cmf_third_party_user` CONVERT TO CHARACTER SET UTF8;

多条SQL：在后面加英文 ';' 号

ALTER TABLE `cmf_third_party_user` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_action` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_action_log` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_balance_log` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_favorite` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_login_attempt` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_score_log` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_user_token` CONVERT TO CHARACTER SET UTF8;

ALTER TABLE `cmf_verification_code` CONVERT TO CHARACTER SET UTF8;