hi, everyone. everytime it would return 0 after I insert a row and use
the get_last_id() to get the inserted auto_increment id. I don't know
what's the reasion and it's so confusion. Can you give some helps?

and the following the process to reproduce.
1. open the "mysql query browser";
2. CREATE TABLE test_tab (`f1` INTEGER NOT NULL AUTO_INCREMENT,`f2`
VARCHAR(30),PRIMARY KEY (`f1`));
3. insert into test_tab(f2) values("a");
4. select * from test_tab;
f1 f2
1 a
5. select last_insert_id();
LAST_INSERT_ID()
0
6. insert into test_tab(f2) values("b");
7. select * from test_tab;
f1 f2
1 a
2 b
8. select last_insert_id();
LAST_INSERT_ID()
0

The results are error of course, the first "select last_insert_id()"
should return 1 and the second should be 2. But the results is correct
in "mysql command line client".

Maybe some of you guys can help me reslove this problem and any helps
for it would be appreciated.

Thanks.

On 2011-06-20 03:03, white_ideal wrote:
[...]

You must invoke last_insert_id() immediate after the insert, see:

http://dev.mysql.com/doc/refman/5.5/...insert-id.html


/Lennart

white_ideal <whiteideal (AT) gmail (DOT) com> wrote:

There is the reason.

LAST_INSERT_ID() and friends rely on information in the current
connection ("session context" or "connection scoped state").
The Query Browser however opens a new connection for each operation
and closes it immediately after.

Better use a real SQL client. Like mysql(.exe)

More details:

http://mysqldump.azundris.com/archiv...-in-MySQL.html


XL