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: <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]

Reply via email to