At 14:32 -0700 7/22/04, Scott Haneda wrote:
I was just reading a forum post on mysql, someone said it was possible in
mysql 4 to insert data into more than one table at once. Is this possible,
if so, where in the docs can I see a example of this?
Scott,
Perhaps you could ask "someone" to provide a
Scott Haneda <[EMAIL PROTECTED]> wrote:
> I was just reading a forum post on mysql, someone said it was possible in
> mysql 4 to insert data into more than one table at once. Is this possible,
> if so, where in the docs can I see a example of this?
Not possible. What is possible is inserting sev
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
Hi all
Thanks for your replies to my question about multiple updates in one query. I think
Kittiphum Worachat is right in that I have designed it wrong. I couldn't get it to do
what I wanted, so I reverted to single update queries.
cheers
Mark
---
Summary of replies
-- from Paul Wilso
Mark
> Does anyone know if it's possible to insert mutilple records into 1
table
> in one query?
yes
> Something like -
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15')
>
> insert into mytable (id,name,job_number,job_date) values
> ('2','Mark','AA2'
Hi.
Just use
INSERT INTO mytable (id,name,job_number,job_date)
VALUES ('1','Mark','AA1','2002-04-15'), ('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17') [and so on...]
Also see http://www.mysql.com/doc/I/N/INSERT.html
Bye,
Benjamin.
On Sun, Apr 14, 2002 at 11:10:22PM
Many thanks for that.
cheers
Mark
On Mon, 15 Apr 2002, Kittiphum Worachat wrote:
> Hi.
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
> 'AA3','2002-04-17'),
>
> Kittiphum Worachat,M.T.
> www.ha
Hi.
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
'AA3','2002-04-17'),
Kittiphum Worachat,M.T.
www.hatyailab.com
>
> Does anyone know if it's possible to insert mutilple records into 1 table
> in one q
* Egor Egorov
> AC> REALFROM: "Anton Chalbaud" <[EMAIL PROTECTED]>
> AC> HOUR: 2002033122
>
> AC> Hi, if I need to do multiple INSERTS (I mean into different
> tables) which is
I think he asked about inserting into multiple tables... ;)
--
Roger
query
---
I would think an UPDATE would suit you just fine.
UPDATE mytable SET price=price*1.21 WHERE ...
- Original Message -
From: "fano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 23:01
Subject: multiple inserts
> Hello mysql,
>
> Hi, I have a table "Invoices",
16 matches
Mail list logo
