Hi Bruce
What Fred said is true. Only transactions will help you.
Regards
Visolve DB Team
----- Original Message -----
From: "Frederic Wenzel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Visolve DB Team" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Tuesday, August 15, 2006 1:01 PM
Subject: Re: multiple table inserts
Bruce,
why do you want to do that at all?
If you need to add values to several tables either at once or (in case
of an error) not at all, you should use transactions.
Fred
On 8/15/06, bruce <[EMAIL PROTECTED]> wrote:
----- Original Message -----
From: "bruce" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, August 15, 2006 7:56 AM
Subject: multiple table inserts
> hi...
>
> the mysql docs don't seem to allow this.. but i'll ask.
>
> is there a way to accomplish:
>
> insert into cat,dog (cat.x,dog.y) values (1,2)
>
> allowing me to essentially insert items into multiple tables
> simultaneously...
>
> thanks
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
