My SQL Dynamic query execute and get ouput into a variable in stored procedure
Have a look at this example – CREATE TABLE table1( column1 VARCHAR(255) DEFAULT NULL, column2 VARCHAR(255) DEFAULT NULL, column3 VARCHAR(255) DEFAULT NULL ); INSERT INTO table1 VALUES (‘1’, ‘value1’, ‘value2’), (‘2’, ‘value3’, ‘value4’); DELIMITER $$ CREATE PROCEDURE procedure1(IN Param1 VARCHAR(255), OUT Param2 VARCHAR(255), OUT Param3 VARCHAR(255)) BEGIN SET @c2 = ”; SET @c3 = ”; … Read more