MySQL Forums
Forum List  »  Stored Procedures

How to create Stored Procedure to INSERT multiple Rows in a table
Posted by: Hemant Mehta
Date: April 25, 2020 10:21PM

I am using version 6.3 of MySQL.
Requirement is to create a Stored Procedure which can INSERT multiple rows into a table where table has 10 columns.
The number of rows to be inserted is dynamic and would depend on the incoming file from caller Application.
Can anyone help on this
As how to create a SP to accept an Array of Data with dynamic length (because rows can be varying)
How to call the SP.
Any pointers and help will be appreciated.
Thanks in advance.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.