//不推荐写法
修改表的默认字符集:
ALTER TABLE table_name DEFAULT CHARACTER SET character_name;
//推荐写法
修改表字段的默认字符集:
ALTER TABLE table_name CHANGE field field field_type CHARACTER SET character_name [other_attribute]
修改表的默认字符集和所有列的字符集:
ALTER TABLE table_name CONVERT TO CHARACTER SET character_name
测试用例中SQL是推荐写法,SQL如下:
alter table t1 convert to character set utf8 collate utf8_unicode_ci;
//不推荐写法 修改表的默认字符集: ALTER TABLE table_name DEFAULT CHARACTER SET character_name;
//推荐写法 修改表字段的默认字符集: ALTER TABLE table_name CHANGE field field field_type CHARACTER SET character_name [other_attribute] 修改表的默认字符集和所有列的字符集: ALTER TABLE table_name CONVERT TO CHARACTER SET character_name
测试用例中SQL是推荐写法,SQL如下: alter table t1 convert to character set utf8 collate utf8_unicode_ci;