my sql里面的1064错误——[Err] 1064 - You have an error in your SQL syntax;

时间:2022-04-23 00:57:32
[Err] 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 'INSERT INTO result(studentNo,subjectNo,examDate,studentResult)

VALUES (10002,1,' at line 3


解决办法为:原来是里面

/*--关闭事务自动提交--*/
SET autocommit = 0;
/*--开启新事务--*/
START TRANSACTION;


/*--插入数据--*/
INSERT INTO result(StudentNo,SubjectNo,ExamDate,StudentResult)
            VALUES(10001,1,NOW(),90)
            
INSERT INTO result(StudentNo,SubjectNo,ExamDate,StudentResult)
            VALUES(10002,1,NOW(),70);
            
INSERT INTO Result(StudentNo,SubjectNo,ExamDate,StudentResult)
            VALUES(10003,1,NOW(),67);
/*--提交事务--*/           
COMMIT;
/*--插入错误数据--*/           
INSERT INTO Result(StudentNo,SubjectNo,ExamDate,StudentResult)
            VALUES(10004,1,NOW(),101);
            
INSERT INTO Result(StudentNo,SubjectNo,ExamDate,StudentResult)
            VALUES(10005,1,NOW(),102);
/*--回滚事务--*/            
ROLLBACK;
/*--开启自动提交--*/ 
SET autocommit = 1;

有的行数没有加分号造成的。

加分号后运行成功!还是my sql里面的1064错误——[Err] 1064 - You have an error in your SQL syntax;