DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `supplierInfo`()
BEGIN
DECLARE number VARCHAR(4);
DECLARE qty int(6);
DECLARE FOUND BOOLEAN DEFAULT TRUE;
DECLARE cur CURSOR FOR
SELECT DISTINCT spj.snumber, SUM(spj.qty)
FROM spj
GROUP BY spj.snumber;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET FOUND = false;
OPEN cur;
FETCH cur INTO number, qty;
WHILE(FOUND)DO
SELECT CONCAT('(Supplier = ',number,', total Part qty = ',qty,')') AS snumber_And_total_Qty;
FETCH cur INTO number, qty;
END WHILE;
CLOSE cur;
END$$
DELIMITER ;