Getting the last_auto increment value

[perlone]

Hello,

I was wondering if anyone could show me how to get the last auto increment value from a table called 'news'. Thank You so much.

There is no Knowledge that is not power.
Age: 17
E-mail: projectnet01@yahoo.com
Companynot done yet)
Status: Currently working with C++ for game developing. And making a musical band.
-Aaron

 

[vbkris]

maybe a workaround is possible, but i need to know the logic...

Known is handfull, Unknown is worldfull

 

[swampBoogie]

After an insert you can get the value with

select last_insert_id()