Index column size too large. The maximum column size is 767 bytes.

1:在建表语句的后面加入：ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

例：

CREATE TABLE QRTZ_JOB_DETAILS
(
SCHED_NAME VARCHAR(120) NOT NULL,
JOB_NAME VARCHAR(200) NOT NULL,
JOB_GROUP VARCHAR(200) NOT NULL,
PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

 

2：Navicat 打开设计表；引擎选择InnoDB，行格式选择：InnoDB

 

3：MySQL配置文件修改数据库搜索引擎

default-storage-engine=INNODB
innodb_large_prefix=ON
innodb_file_format=barracuda
innodb_file_per_table=ON