create procedure sp_sw2()

 begin

 declare error int default 0;

 declare continue handler for SQLEXCEPTION set error=1;

  START TRANSACTION;

 insert into t_student values('100','20169998','段天德1','男',20,'信息息');

  insert into t_student values(1,'20169999','段天德1','男',20,'信息息');

      if error=1 then

        ROLLBACK;

      else

         COMMIT;

      end if;

      end;