mysql5.7报错SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_gene

1、首先数据库执行以下命令：

SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;') AS sql_statement
FROM information_schema.tables
WHERE table_schema = 'your_database_name';

2、运行后将会输出对应的sql语句，如下图：

3、将输出的sql语句复制批量执行即可