mysql 修改某字段的格式为 utf8mb4

ALTER TABLE confession MODIFY `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

#查看表中字段字符集
SHOW FULL COLUMNS FROM confession;