[thelist] Sql muti table insert needing auto increment value
Anthony Baratta
Anthony at Baratta.com
Fri Aug 8 13:13:03 CDT 2003
At 10:40 AM 8/8/2003, 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?
Insert into first table and then get the ID added by the DB Engine for use
with the other inserts.
SELECT LAST_INSERT_ID()
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list