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
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
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
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
Sorry! My mistake. In MySQL-Front I had the Limit option check and
wasn't seeing the newly inserted records.
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
If you don't have any error message, what make you think it doesn't
work?
FYI, I have run the following commands from mysql client:
mysql use test
Database changed
mysql create table Table1 (Id int not null auto_increment primary key,
Product varchar(80), Qty int);
Query OK, 0 rows affected
Sorry Joseph, you must've missed my next post minutes later. I had the
limit option accidentally set in MySQL-Front and the newly inserted
records weren't appearing.
Another question though, I continued testing this and found that if I
use MSAccess as the front end to the MySQLserver the