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
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
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
