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]