just to make it clearer: select * from your_table order by auto_increment_column desc limit 5 cheers :) ----- Original Message ----- From: "Luis Ferro" <[EMAIL PROTECTED]> To: "'Jack'" <[EMAIL PROTECTED]>; "'Mysql List'" <[EMAIL PROTECTED]> Sent: Monday, November 26, 2001 6:30 PM Subject: RE: Getting to latest 5 Records
> The best way is to get the records ordered inverselly by the auto-increment > field and then restrict the return to 5 records. > > Cheers, > Luis Ferro > WebDev > > -----Original Message----- > From: Jack [mailto:[EMAIL PROTECTED]] > Sent: segunda-feira, 26 de Novembro de 2001 10:02 > To: Mysql List > Subject: Getting to latest 5 Records > > > Dear all > I had a table which with Auto_increment, which means when i insert a record > there will be a number insert to lead as the location of the record. > here is my question. > I was try to get the most last five records , but i don't know which query > should i use? > > Thx > Jack > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
