Finding the last record on a MySQL table?

AQG · 07-12-2005, 12:14 PM

Hi can some one enlighten me with an instruction to find the last record on a mysql table.
thanks

Matir · 07-12-2005, 02:36 PM

Define "last"... the order in which records are stored is arbitrary. Do you mean greatest by a particular index?

Code:

SELECT column1,column2 FROM tablename ORDER BY indexcolumn DESC LIMIT 1;

AQG · 07-13-2005, 10:41 AM

Ok, thanks, i've got it, but now i have another question:

i've used in one of my tablesa field that contains an id number which automaticly increments every time i add a record to the table, but my problem now is that if i erase the records i have in the table when i insert a new record the id number doesn't start from 1 it starts for example in 20 because i had erased 19 records before.
any suggestions on how to clear that problem?

thanks in advance!!!!1

Matir · 07-13-2005, 10:55 AM

The current value of the auto_increment column is stored in the table descriptions in MySQL. The only way (that I know of) to reset it is to drop the table and re-create it from scratch.

AQG · 07-13-2005, 11:44 AM

OK THANK YOU!!!!

UNTIL NEXT TIME

Matir · 07-13-2005, 12:55 PM

No problem. Just glad I was able to help.