训练要点
-- 使用事务表中插入多条记录
-- 批量插入参加今天Logic java 课程考试当前十名学生成绩
-- 如果输入的成绩大于100分,则取消操作
BEGIN;
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 1,1,'2024-5-24','100');
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 2,1,'2024-5-24','100');
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 3,1,'2024-5-24','100');
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 4,1,'2024-5-24','100');
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 5,1,'2024-5-24','100');
COMMIT;
BEGIN;
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 6,1,'2024-5-24','100');
INSERT INTO result (`studentNo`,`subjectNo`,`examDate`,`studentResult`) VALUES ( 7,1,'2024-5-24','200');
ROLLBACK;