gistfile1.txt

USE ap;
DROP PROCEDURE IF EXISTS test;

DELIMITER 
CREATE PROCEDURE test(IN vid_input INT, OUT message VARCHAR(500))
BEGIN
    DECLARE term_id VARCHAR(225);  
    
    SELECT default_terms_id 
    INTO term_id 
    FROM vendors 
    WHERE vendor_id = vid_input;
    
    CASE term_id
		WHEN 1 THEN 
			SET message = 'Net due 10 days';
		WHEN 2 THEN 
			SET message = 'Net due 20 days';
		WHEN 3 THEN 
			SET message = 'Net due 30 days';
		ELSE
			SET message = 'Net due more than 30 days';
	END CASE;
END