mysql 最后一个id,MySQL获取特定表的最后一个ID

I have to get last insert id from a specific inserted table?.

Lets say i have this code:

INSERT INTO blahblah (test1, test 2) VALUES ('test1', 'test2');

INSERT INTO blahblah2 (test1, test 2) VALUES ('test1', 'test2');

INSERT INTO blahblah3 (test1, test 2, lastid) VALUES ('test1', 'test2', last id of blahblah);

How do i get the insert id of table blahblah in table blahblah3?

LAST_INSERT_ID() only gives you the last insert id

Regards, Simon :)

解决方案

You can use LAST_INSERT_ID() function.

Try this:

INSERT INTO blahblah (test1, test2) VALUES ('test1', 'test2');

SELECT LAST_INSERT_ID() INTO @blahblah;

INSERT INTO blahblah2 (test1, test2) VALUES ('test1', 'test2');

INSERT INTO blahblah3 (test1, test2, lastid) VALUES ('test1', 'test2', @blahblah);