[thelist] Sql muti table insert needing auto increment value

[Steve Lewis]

fstorr wrote:

>Hi all
>
>I need to do a SQL insert statement into three tables.  However, the
>second table contains a column which is a foreign key to the first
>table's auto incrementing index.  How do I insert this value into the
>second table (I'm using PHP+MySQL) when I don't actually know what it
>is?
>  
>
Anthony just answered your question, but to recap what was said July 21 
after several days of discussion:

 > in order of preference, here are the techniques --
 > 1 @@identity, mysql_last_id, or whatever method the database provides
 > 2 INSERT, then SELECT back using the "real" primary key value(s)
 > 3 transaction block around INSERT, SELECT MAX(id)

> note that there is absolutely no danger of getting the wrong row back using
> method 2, and further, method 2 does not require a transaction block

> rudy


http://lists.evolt.org/archive/Week-of-Mon-20030721/145197.html

Steve