Problem in inserting multiple rows using stored procedure

[prashanth023]

Hi ,

Can any body please solve the problem

I need a stored procedure that should take a number as input for number of records to insert.

And it should take the row by row data and insert n number of records. in command prompt


Please colve my problem.

[mwasif]

Take a look at these links, try to make a stored procedure. If you still face problems post back here.

http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.pdf

[mocode]

Hi there,

the links provided didnt help me. I am not sure whether my problem is the same as the one mentioned above.

Anyways: I am looking for a possibility to send some kind of array to a stored proc:
Instead of
loop cartItems
call insertOrderline ()
end loop

I would like to
Call insertorder(car tItems)

Is that possible at all?

Thanks for any hints!