Get Last Row

[Zunath]

I'm using AUTO_INCREMENT in my tables to give them unique ID's. What I'm trying to do is get the value in column "id" of the most recent row addition.

I've searched on google and found a few things that I thought would work but my limited knowledge of MySQL is preventing me from solving the problem on my own. ><

I can easily set a variable in the database to keep track of the number of rows but I was hoping to avoid that.

Would someone mind helping me out with this? I appreciate it.

[Quixsilver]

select max(id) from <table>;

Should work... if it doesn't, I'm installing Oracle lol.

[Zunath]

Awesome, it worked. Thanks

[Borys]

In MySQL 4.1: SELECT LAST_INSERT_ID();
Read all about this to avoid mistakes using it