错误:1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
出现错误:(1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")
错误的原因是由于新生成的表的字符集是latin1_swedish_ci,而原有的字符集需要utf8_general_ci,所以报错。
解决方法:修改所有表的字符集为utf8即可
alter table ‘数据库名称’ convert to character set utf8;