sql - How can I send a table as a parameter to stored procedure in MySQL?

Question

I have a stored procedure in MySQL like:

DELIMITER $$
CREATE PROCEDURE addIns(IN insCode VARCHAR(21), IN insName VARCHAR(21), IN stat BIT(1))
BEGIN
    INSERT INTO institution(institution.institution_code, institution.institution_name, institution.is_active) 
    VALUES (insCode, insName, stat);
END$$
DELIMITER ;

But I want like this:

DELIMITER $$
CREATE PROCEDURE addIns(IN _institution)
BEGIN
    INSERT INTO institution(institution.institution_code, institution.institution_name, institution.is_active)
    VALUES (_institution.institution_code, _institution.institution_name, _institution.is_active);
END$$
DELIMITER ;

Because I want to use this stored procedure in Java Spring App. How can I provide it?

My instutuion table is:

question from:https://stackoverflow.com/questions/65541366/how-can-i-send-a-table-as-a-parameter-to-stored-procedure-in-mysql

Answer 1

CREATE PROCEDURE addIns(IN _institution)
BEGIN
    @sql := CONCAT( 'INSERT INTO institution (institution_code, institution_name, is_active) SELECT institution_code, institution_name, is_active FROM ' , _institution);
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DROP PREPARE stmt;
END