MySQL Forums
Forum List  »  InnoDB

How to iterate trough list in string
Posted by: Boris Masnec
Date: December 23, 2010 04:16AM

Hi,
I tried to find a solution but I found none yet ...

Since MySQL Connector can not pass array as a parameter, I would like to pass in the stored procedure list of ID's in comma-delimited string (parameter type varchar) and then using that list to make multiple inserts or updates.

My question is how to iterate trough string list? If this is impossible then how to do it in a stored procedure?

I was looking for a solution on the forum but have not succeeded to find it. At least not some that works in stored procedure.

I'd also be very grateful if someone publish some example or refer me to some because I have not succeeded to found none of written in the MySQL procedure, only
PHP etc.

I need a solution that works in a stored procedure because it is part of a sequence of transactions.

Thanks in advance!



Edited 1 time(s). Last edit at 12/26/2010 01:57PM by Boris Masnec.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to iterate trough list in string
4329
December 23, 2010 04:16AM
1436
December 24, 2010 10:59AM
1931
December 27, 2010 09:27AM
1321
December 28, 2010 03:35PM


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.