MySQL Procedures and Functions for Data Retrieval

DELIMITER //

CREATE PROCEDURE display_wrappers(IN description VARCHAR(255)) BEGIN SELECT id, rate FROM wrapper WHERE description = description; END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE display_low_price_wrappers(IN price FLOAT) BEGIN SELECT * FROM wrapper WHERE price < price; END //

DELIMITER ;

DELIMITER //

CREATE FUNCTION get_shopper_password(id INT) RETURNS VARCHAR(255) BEGIN DECLARE password VARCHAR(255); SELECT password INTO password FROM shopper WHERE id = id; RETURN password; END //

DELIMITER ;

DELIMITER //

CREATE FUNCTION get_country_name(id INT) RETURNS VARCHAR(255) BEGIN DECLARE name VARCHAR(255); SELECT name INTO name FROM country WHERE id = id; RETURN name; END //

DELIMITER ;

DELIMITER //

CREATE FUNCTION get_recipient_phone(order_num INT) RETURNS VARCHAR(255) BEGIN DECLARE phone VARCHAR(255); SELECT phone INTO phone FROM recipient WHERE order_number = order_num; RETURN phone; END //

DELIMITER ;