reterieving the most recently added data from MySQL

[Norgy]

i want to get the most recently added data from MySQL
for example, if we have a table named test with column : id
the data is inserted as follows: 2, 4, 1, 3
when i type this query :

SELECT * FROM test ORDER BY id DESC LIMIT 1

, it returns 4
but i want a query that returns 3 (the last inserted data)
can i do this?

[Rabbit]

Use an auto increment field or include a column with a timestamp.

[Norgy]

i tried the auto increment field, but it makes me drop the primary key of the table and make that field the pk
i want the table as it is without changing anything in it

[Rabbit]

The auto increment should probably be the primary key. Any other keys should be a unique index. But if you don't want to do it that way, then use the timestamp field instead.

If you mean you want to do that query without changing the table at all, then it's impossible. You need a way to identify when the row was added so you can find the most recent. And to do that, you need to add a field because you currently have nothing to identify the most recent row.

[Norgy]

i used the timestamp field and it works correctly
thanks a lot :)