EXPLAIN
查看表字符集
SHOW TABLE STATUS LIKE '%rms%';
查看列字符集
show full columns from t_user;
alter table rms_xxx convert to character set 'utf8mb4';
EXPLAIN
修改表字符集
ALTER TABLE t_user CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
修改列字符集
ALTER TABLE t_user MODIFY name VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;