sql语句报错，请大神看下哪里的错误

Question

错误代码： 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE
) ENGINE=INNODB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8' at line 15

 CREATE TABLE `task_schedule_job` (
  `job_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `create_time` TIMESTAMP NULL DEFAULT NULL,
  `update_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `job_name` VARCHAR(255) DEFAULT NULL,
  `job_group` VARCHAR(255) DEFAULT NULL,
  `job_status` VARCHAR(255) DEFAULT NULL,
  `cron_expression` VARCHAR(255) NOT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  `bean_class` VARCHAR(255) DEFAULT NULL,
  `is_concurrent` VARCHAR(255) DEFAULT NULL COMMENT '1',
  `spring_id` VARCHAR(255) DEFAULT NULL,
  `method_name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`job_id`),
  UNIQUE KEY `name_group` (`job_name`,`job_group`) USING BTREE
) ENGINE=INNODB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

Answer 1

LZ试试把这句

 UNIQUE KEY `name_group` (`job_name`,`job_group`) USING BTREE

改成这样：

 UNIQUE KEY `name_group` USING BTREE (`job_name`,`job_group`)