Welcome Guest, Not a member yet? Register   Sign In
Insert into multiple tables.
#5

[eluser]Ralanyo[/eluser]
Thanks srpurdy,

just to clarify. I'm assuming i would use the insert_id() to extract the id from the first query/ table to insert it into my second tables relationship column. Is this correct? I think i said that right.

One more question. Does this scale with more than two tables? Just trying to figure out the best practices moving foraward or if i'm just going to make the db innodb and create the foreign keys. Thanks in advance



Messages In This Thread
Insert into multiple tables. - by El Forum - 08-08-2012, 10:16 PM
Insert into multiple tables. - by El Forum - 08-08-2012, 10:54 PM
Insert into multiple tables. - by El Forum - 08-09-2012, 02:59 PM
Insert into multiple tables. - by El Forum - 08-09-2012, 08:51 PM
Insert into multiple tables. - by El Forum - 08-09-2012, 09:01 PM
Insert into multiple tables. - by El Forum - 08-09-2012, 09:07 PM
Insert into multiple tables. - by El Forum - 08-09-2012, 09:09 PM
Insert into multiple tables. - by El Forum - 08-09-2012, 09:15 PM



Theme © iAndrew 2016 - Forum software by © MyBB