MySQL错误：General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) ...

General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

查看当前数据库的默认编码：

show variables where Variable_name like 'collation%';

编码不一致

 

修改排序所有 表 列 排序规则

 

 

 

 

参考：https://blog.csdn.net/phpstory/article/details/116530302