Jose Disla Santiago jdisla

## sql.md

      
        
          
            
              
              1 file
            
          
          
            
              
              4 forks
            
          
          
            
              
              2 comments
            
          
          
            
              
              8 stars
            
          
        
        
          
              
          
          
            
                anilahir
                / sql.md
            
            
              Created
              December 20, 2019 08:14
            
              
                MySQL transaction within stored procedure example
              
          
        
      
        
  
      
    Create stored procedure :

DROP PROCEDURE IF EXISTS sp_delete_users_till_date;

DELIMITER //

CREATE PROCEDURE sp_delete_users_till_date(location_id INT, till_date DATE)