According to your first post, your fields are named ID, PartNum, Qty. May be replacing 'Product' with 'PartNum' will help. You should only remove outer parens:
Insert Into Table1 (Product, Qty) Values ("56-56", 5), ("27-01", 1), ("15-02", 2); If it does not work, you should also post the error message you are getting from mysql. Regards, Joseph Bueno Ed Reed wrote: > 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