Re: Auto-Increment the ID of a table

[Felix Geerinckx]

Jason M wrote:

> I've set the ID column to auto-increment, but I am still going to need to select that last row added
> afterwards so that I can use that value for the ID value of my second table. I hope that makes sense.

You need LAST_INSERT_ID():

CREATE TABLE foo1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE foo2 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, foo1_id INT NOT NULL);

INSERT INTO foo1 (id) VALUES(NULL);
INSERT INTO foo2 (id, foo1_id) VALUES(NULL, LAST_INSERT_ID());

--
felix