跳到主要內容

MySQL 指令集

查詢 table 的 Collation[code]SHOW FULL COLUMNS FROM my_tablenameSHOW FULL COLUMNS FROM adam_session[/code]變更欄位 Charset[code]ALTER TABLE my_tablename MODIFY fieldname CHAR(50) CHARACTER SET utf8mb4ALTER TABLE adam_session MODIFY sess_data longtext CHARACTER SET utf8mb4[/code]
MySQL 指令集
查詢 table 的 Collation
[code]
SHOW FULL COLUMNS FROM my_tablename
SHOW FULL COLUMNS FROM adam_session
[/code]

變更欄位 Charset
[code]
ALTER TABLE my_tablename MODIFY fieldname CHAR(50) CHARACTER SET utf8mb4
ALTER TABLE adam_session MODIFY sess_data longtext CHARACTER SET utf8mb4
[/code]