DELIMITER $$
CREATE PROCEDURE `delete_allcard`()  
     BEGIN  
     DECLARE t_error INTEGER DEFAULT 0;  
     DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;  
   
         START TRANSACTION;  
		delete from sc_card;
		delete from sc_consume;
		delete from sc_recharge;     
   
         IF t_error = 1 THEN  
             ROLLBACK;  
         ELSE  
             COMMIT;  
         END IF;  
      select t_error;   
  END;