mysql查询、修改数据库编码 更改utf8 到 utf8mb4
-- 查询单表数据库编码
show full columns from sys_user;
-- 查询编码
SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';
-- 修改表编码
ALTER TABLE sys_user CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE account CONVERT TO CHARACTER SET utf8mb4;
-- 修改数据库编码
ALTER DATABASE mydb CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;