CREATE PROCEDURE 'seckill'.'execute_seckill'(IN v_seckill_id bigint,IN v_phone bigint,IN v_kill_time TIMESTAMP ,out r_result INT )
BEGIN
 DECLARE insert_count INT DEFAULT 0;
 start TRANSACTION ;
 INSERT ignore INTO success_killed(seckill_id,user_phone,create_time) VALUES (v_seckill_id,v_phone,v_kill_time);
 SELECT ROW_COUNT() INTO insert_count;
 IF(insert_count==0) THEN
   ROLLBACK ;
   SET r_result=-1;
 ELSEIF(insert_count<0) THEN
   ROLLBACK ;
   SET r_result=-2;
 ELSE
    update seckill set number = number - 1
     where seckill_id = #{seckillId}
      and start_time &lt;= #{killTime}
      and end_time >= #{killTime}
      and number > 0;
   SELECT ROW_COUNT() INTO insert_count;
   IF(insert_count==0) THEN
     ROLLBACK ;
     SET r_result=0;
   ELSEIF(insert_count<0) THEN
     ROLLBACK ;
     SET r_result=-2;
   ELSE
     COMMIT ;
     SET r_result=1;
   END IF;
 END IF;
END ;
$$