My question is how do I send multiple sets of data into a stored
procedure
without doing the things I had outlined.
MySQL doesn't have arrays. Pass the data in a comma-delimited string
and PREPARE the statement, or pass it as a temp memory table.
PB
-----
L P wrote:
Chris,
thank you for the response, but that was not my question.
My question is how do I send multiple sets of data into a stored
procedure
without doing the things I had outlined.
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
L P wrote:
> Folks,
> say I have a need to add multiple rows at the same time.
>
> for instance, say I'm collecting customer information and I want
to add
3
> addresses and 3 phone numbers at the same time for a customer.
>
> The above is quite straightforward to accomplish when there is
only one
set
> of data to deal with (one address / one phone number) - with
simple data
> types passed in as parameters.
>
> What alternatives / options do I have to accomplish storing
multiple
> sets of
> data?
insert into table(field1, field2, field3) values (value1, value2,
value3), (value4, value5, value6);
http://dev.mysql.com/doc/refman/5.1/en/insert.html
Don't use arrays for storage, you'll lose a lot of performance.
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 7/24/2006
|
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 7/24/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]