Re: select last row

2005-02-17 Thread Gleb Paharenko
Hello. This is a frequently asked question in the list. See for example: http://lists.mysql.com/mysql/176753 "Mulley, Nikhil" <[EMAIL PROTECTED]> wrote: > 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

RE: select last row

2005-02-14 Thread Tom Crimmins
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

Re: select last row

2005-02-14 Thread matt_lists
Mulley, Nikhil wrote: 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 Do you use a recno? If you have 4.1 you can use select * from table where recno = (se

select last row

2005-02-14 Thread Mulley, Nikhil
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists