字段字符集修改:
ALTER TABLE test_tab MODIFY `col1` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
查看下是否修改成功:
SHOW FULL COLUMNS FROM confession;
字段字符集修改:
ALTER TABLE test_tab MODIFY `col1` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
查看下是否修改成功:
SHOW FULL COLUMNS FROM confession;