Mysql Stored Procedure Programming

DELIMITER $$ CREATE PROCEDURE get_product_details(IN product_id INT) BEGIN SELECT product_name, product_price, product_description FROM products WHERE product_id = product_id; END$$ DELIMITER ; CALL get_product_details(1);