---

DELIMITER //
CREATE PROCEDURE PRnm (IN shifr VARCHAR(20), OUT nm VARCHAR(255))
BEGIN
    SELECT project INTO nm 
    FROM project 
    WHERE shift = shifr;
END //
DELIMITER ;