If you have an auto_increment column, SELECT * FROM my_table ORDER BY auto_increment_col DESC LIMIT 1
If you don't have an auto_increment this might be a good time to add one. > -----Original Message----- > From: Mulley, Nikhil [mailto:[EMAIL PROTECTED] > Sent: Monday, February 14, 2005 08:15 > To: mysql@lists.mysql.com > Subject: select last row > > Hi All, > I have a table which is being continuosly updated, I just > wanted to know how to output only the last row with the > select statement. > can anyone please tell me howto. > thanks, > Nikhil > --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
