|
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
| 
转播
