I created a new table called Table1 and did a test with that command. My
test table does have all three fields that I mentioned. The ID field is
an autoincrement. The other fieldnames match what's in my command.
I'm running the command from MySQL-Front and it doesn't return any
error message it just doesn't insert the new records. If I include the
outer parens then it tells me there's an error in my syntax.
- Thanks
>>> Joseph Bueno <[EMAIL PROTECTED]> 12/1/2002 12:00:21 PM >>>
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
