Re: [newbie] Get ID from previous INSERT?

[John Doe]

Done:

=========
CREATE TEMPORARY TABLE dummy (id MEDIUMINT NOT NULL AUTO_INCREMENT,name CHAR(30) NOT NULL,PRIMARY KEY (id));
INSERT INTO dummy (name) VALUES ('blah');
SET @id=LAST_INSERT_ID();
SELECT @id;
INSERT INTO dummy (name) VALUES (@id);
SELECT * FROM dummy;
DROP TABLE dummy;
=========