mysql-run

DELIMITER // 
CREATE PROCEDURE GetOfficeByCountry(IN countryName VARCHAR(255)) 
BEGIN 
SELECT city, phone 
FROM offices 
WHERE country = countryName; 
END // 
DELIMITER ;


CALL GetOfficeByCountry('USA') 
CALL GetOfficeByCountry(‘France’)