MySQL更新语句出现 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IM

解决方案如下

ALTER TABLE 表名CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;