salix/db/routines/vn/procedures/itemSearchShelving.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`itemSearchShelving`(`vShelvingFk` VARCHAR(3))
BEGIN
	SELECT p.`column` AS col , p.`row`
		FROM vn.shelving s 
			JOIN parking p ON s.parkingFk = p.id 
		WHERE s.`code` = vShelvingFk COLLATE utf8_general_ci;
END$$
DELIMITER ;