fetch last row in a table..

[joinx]

How to select and retrieve data that has been inserted from the last row of a table...?

 

[BlueSkyIS]

use ORDER BY DESC (descending) in your query, for instance:

 

SELECT * FROM some_table ORDER BY name DESC

 

then take the first record. alternatively, you might use MAX() to pull the max value of a column.

[moselkady]

If you have a filed, e.g. id, that is auto incremented, you can try this

 

SELECT * FROM mytable ORDER BY id DESC LIMIT 1