mysql存储过程加事务

 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;