如何在SQL语句出现错误时启动事务,系统会自动回滚更改?我有以下SQL语句STARTTRANSACTION;BEGIN;INSERTINTO`users`(id,name,gender,email,age)VALUES(11121,'sss',0,'ssss',22);INSERTINTO`teachers`(`UserId`,`teachingSubject`)VALUES(11121,300);COMMIT;当第二条语句发生错误时,它不会回滚。为什么?'teachingSubject'是TINYINT(2),第二条语句将超出其范围。我想回滚所有语句。Belowismyprocedu