Finding the next 'autoindex'. 1

[perlone]

Is there anyway I can find the next autoindex integer using mySQL? Thank You.

-Aaron 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

 

[r937]

no, but you can find the last one inserted

see

http://www.mysql.com/doc/en/mysql_insert_id.html

rudy

 

[perlone]

thank you! 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

 

[perlone]

hi,

I was wondering if you could show me the right way. I tried this way:

$sql = select LAST_INSERT_ID() from news_index

It seems not working. Thank You again for your help. 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

 

[danielhozac]

How can you tell that it isn't working? The correct query would be [tt]SELECT LAST_INSERT_ID()[/tt], you don't need the [tt]FROM ...[/tt] part of the query.

As a side note, if you are using PHP or any other language that has an interface the MySQL client library, then the function [tt]mysql_insert_id()[/tt] should be available. //Daniel