> I am using version 6.3 of MySQL
No such version. 6.3 sounds like a WorkBench version.
> create a Stored Procedure which can INSERT multiple
> rows into a table where table has 10 columns ....
> accept an Array of Data with dynamic length
Is this homework? The specification is odd ...
The only arrays in MySQL are JSON. For how to turn a JSON table into a relational table in MySQL, see https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
If that's not what's meant, then if the sproc is to receive its specs as a huge number of declared parameters, there will be so many of them, the sproc will be so awkward and error-prone, it will be unusable.
On the other hand, if the sproc is to receive params in the natural way to do such jobss in SQL, that is via a table, then the table whose name is being passed in is already the solution to the problem.
So it seems to me something is missing in this spec.
For an example of a set of sprocs which populate a given table with random data, see http://kedar.nitty-witty.com/blog/generate-random-test-data-for-mysql-using-routines?unapproved=134660&moderation-hash=f9b4a34aca50d4cfded712b54bbf76eb
Edited 1 time(s). Last edit at 04/26/2020 10:09AM by Peter Brawley.