Re: INSERT records into multiple tables

2001-03-17 Thread Patrick Calkins
ED]] > Sent: Friday, March 16, 2001 3:47 PM > To: [EMAIL PROTECTED] > Subject: INSERT records into multiple tables > > > I'm just learning how to use MySQL and I am searching for a more simple way > of doing an INSERT query into multiple tables simultaneously. > I have

RE: INSERT records into multiple tables

2001-03-16 Thread Cal Evans
you can't. You have to do 2 seperate inserts. (Sorry) Cal http://www.calevans.com -Original Message- From: Bryan Wheelock [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:47 PM To: [EMAIL PROTECTED] Subject: INSERT records into multiple tables I'm just learning

Re: INSERT records into multiple tables

2001-03-16 Thread Jason Landry
t;,$link_id) or die(mysql_error());// assumes auto_increment I just typed this in without trying it in any way, so don't tryo to run it as is -- but it should give you an idea. - Original Message - From: "Bryan Wheelock" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]&

INSERT records into multiple tables

2001-03-16 Thread Bryan Wheelock
I'm just learning how to use MySQL and I am searching for a more simple way of doing an INSERT query into multiple tables simultaneously. I have done my best to nominalize my DB but that creates but I'm confused as to how to insert data into the DB and have all the related table be updated. I thin