Thanks for the response. I tried your example but it doesn't work,
Here's my SQL, can you tell what I'm doing wrong?
Insert Into Table1 (Product, Qty)
Values (("56-56", 5), ("27-01", 1), ("15-02", 2));
I've tried it with and without the outer parens.
Thanks
>>> "Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >>>
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
> -----Original Message-----
> From: Ed Reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 30, 2002 3:47 PM
> To: [EMAIL PROTECTED]
> Subject: Multiple Inserts and updates
>
>
> Can anyone give me an example of how to insert and/or update
> multiple records in the same table simultaneously?
>
> I have a table with three fields; ID, PartNum, Qty. The user
> enters PartNum and Qty data in an unbound grid UI. When the
> user hits "Save" I'd like to build a single SQL statement
> from the data in the grid and have that one statement update
> or insert the rows in the table as necessary. I don't wanna
> have to build a separate SQL statement for each row of the
> grid (which is the only way I know how at this moment).
>
> Any help would be appreciated.
>
>
---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
