Error Code: 1253. COLLATION ‘utf8_general_ci‘ is not valid for CHARACTER SET ‘utf8mb4‘

## 解决方法

将对应的sql文件中的

utf8mb4_0900_ai_ci替换为utf8_general_ci
utf8mb4替换为utf8

再次执行sql文件就可以。

链接：https://www.jack361.com/6670.html

Mysql bench出现的中文内容表格信息加入不成功

创建表的示例：

CREATE TABLE `news_type`  (
  `tid` INT NOT NULL AUTO_INCREMENT COMMENT '新闻类型id',
  `tname` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '新闻类型描述',
  `version` INT DEFAULT 1 COMMENT '乐观锁',
  `is_deleted` INT DEFAULT 0 COMMENT '头条是否被删除 1 删除  0 未删除',
  PRIMARY KEY (`tid`) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;