mysql utf8转utf8mb4
更改数据库编码(字符集):
ALTER DATABASE DATABASE_NAME DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
更改表编码(字符集)(注意:这里修改的是表的字符集,表里面字段的字符集并没有被修改):
ALTER TABLE TABLE_NAME DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
更改表编码(字符集)和表中所有字段的编码(字符集):
ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
批量设置
查询生成sql
SELECT
CONCAT(
'ALTER TABLE ‘,
TABLE_NAME,
’ CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;’
)
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = ‘数据库名’;