MySql
第一次写博客 记录自己平常遇见的问题
修改表字段的字符集
ALTER TABLE tbl_name CHANGE c_name c_name CHARACTER SET character_name [COLLATE …];
如:ALTER TABLE user
CHANGE personal_signature personal_signature VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci;
让数据表可存表情的 字符集为 utf8mb4
于是 ALTER TABLE TABLE_NAME
CHANGE COLUM_NAME
COLUM_NAME
VARCHAR(50) CHARACTER SET utf8mb4;