ตอนที่ 4 : การสร้างตัวแปร Declare Variable บน Stored Procedure (MySQL : Stored Procedure)

DECLARE variable_name datatype(size) DEFAULT default_value;

DROP PROCEDURE IF EXISTS getCustomer;

DELIMITER //
CREATE PROCEDURE getCustomer()
BEGIN

	DECLARE x,y INT DEFAULT 0;
	DECLARE iLimitRow INT DEFAULT 1;
	DECLARE sCountryCode VARCHAR(2);
	DECLARE iFoundRow INT DEFAULT 0;
        
	SET sCountryCode = 'US';

	SELECT COUNT(*) INTO x FROM customer;
	SET y = x;
        
	SELECT * FROM customer WHERE COUNTRY_CODE = sCountryCode ORDER BY CUSTOMER_ID LIMIT 0,iLimitRow;
	SET iFoundRow  = FOUND_ROWS();

END //

DELIMITER ;