Re: multiple table inserts

2006-08-15 Thread Visolve DB Team
essage - From: "bruce" <[EMAIL PROTECTED]> To: 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

Re: multiple table inserts

2006-08-15 Thread Frederic Wenzel
OTECTED]> To: 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) > > a

RE: multiple table inserts

2006-08-15 Thread bruce
EMAIL 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

RE: multiple table inserts

2006-08-15 Thread bruce
06 10: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,Fee

Re: multiple table inserts

2006-08-15 Thread Visolve DB Team
OTECTED]> To: 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 mult

Re: multiple table inserts

2006-08-15 Thread Visolve DB TEAM
OTECTED]> To: Sent: Tuesday, August 15, 2006 8:26 PM 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 mult

Re: multiple table inserts

2006-08-15 Thread mark addison
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

multiple table inserts

2006-08-15 Thread bruce
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.mys