'how to select multiple columns in select statement of stored procedure in mysql using 2 different OUT parameter
''' DROP PROCEDURE IF EXISTS load_book_data; DELIMITER $$ CREATE PROCEDURE load_book_data(IN mytitle varchar(50),OUT auth VARCHAR(50),INOUT hike varchar(100))
BEGIN
SELECT price+hike INTO hike, author into auth FROM books where title=mytitle;
END $$
DELIMITER ;
SET @newhike=100;
CALL load_book_data('dbms',@author,@newhike);
SELECT @newhike,@author;
...
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
