Selecting last item

2006-10-03 Thread Deckard
Hello, What is the best approach to select the last row of a table ? Thank you. Warm regards, Deckard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Selecting last item

2006-10-03 Thread Jo�o C�ndido de Souza Neto
When i need to do it i use something like this: select * from table order by column desc limit 1; Deckard [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] Hello, What is the best approach to select the last row of a table ? Thank you. Warm regards, Deckard -- MySQL