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 command
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 (0.
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 mat
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 j
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 me
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]
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 exampl
