以下出错信息怎么解决，MySQL8.0版本

Question

 

 

 

Answer 1

你把表格的主键设置为自动累加(AUTO_INCREMENT),

CREATE TABLE `inStudy`  (
  `inStudyId` int(11) NOT NULL AUTO_INCREMENT,
  `inStudyName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `seq` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`inStudyId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

或者给主键设置值。