create procedure in mysql with parameters code example

Example: mysql stored procedure parameters

DELIMITER //

CREATE PROCEDURE GetOfficeByCountry(
	IN countryName VARCHAR(255)
)
BEGIN
	SELECT * 
 	FROM offices
	WHERE country = countryName;
END //

DELIMITER ;Code language: SQL (Structured Query Language) (sql)