DROP PROCEDURE IF EXISTS proc_test;
CREATE  PROCEDURE proc_test()
BEGIN
  DECLARE t_error INTEGER DEFAULT 0;    
  DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1; 
  START TRANSACTION; 

    insert into score_record_bak(openid, nickname, city_id, city_name, grid_number, score_type, 
   channel_manager_score, channel_manager_remark, railcom_support_score, railcom_support_remark, 
   manager_support_score, manager_support_remark, insert_time, weixin_accountid)
  select openid, nickname, city_id, city_name, grid_number, score_type, 
   channel_manager_score, channel_manager_remark, railcom_support_score, railcom_support_remark, 
   manager_support_score, manager_support_remark, insert_time, weixin_accountid
  from score_record;
  DELETE from dezhou_score_record;

  IF t_error = 1 THEN    
      ROLLBACK;    
  ELSE    
      COMMIT;    
  END IF;  
END;