On Tue, 2006-08-15 at 07:56 -0700, bruce wrote:
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...
If your using
Hell Bruce
Yes ,Here is the solution to insert the values from multiple table into a
table . We can achieve this by using the JOINs(INNER JOIN,LEFT JOIN,RIGHT
JOIN, join)
Consider the tables Animal,Feed and Animalfeed
Structure of the animal table
Id
name
variety
Structure of the feed
Hi Bruce
U can you mysql_insert_id function to insert values into multiple tables.
Please refer to http://www.desilva.biz/mysql/insertid.html for more details.
It also illustrates with examples.
Thanks
Visolve DB Team
- Original Message -
From: bruce [EMAIL PROTECTED]
To:
:55 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: multiple table inserts
Hell Bruce
Yes ,Here is the solution to insert the values from multiple table into a
table . We can achieve this by using the JOINs(INNER JOIN,LEFT JOIN,RIGHT
JOIN, join)
Consider the tables Animal,Feed
PROTECTED]; mysql@lists.mysql.com
Subject: Re: multiple table inserts
Hi Bruce
U can you mysql_insert_id function to insert values into multiple tables.
Please refer to http://www.desilva.biz/mysql/insertid.html for more details.
It also illustrates with examples.
Thanks
Visolve DB Team
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:
: 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