August 18th, 2000, 04:22 AM
I want to select the data from a table sorting desc of the insert order .
That is I want to use select * from table desc; the standard SQL query.
can I do it??
I'm sorry for my poor English!
August 18th, 2000, 08:41 AM
So long as you have some kind of incrementing field for every insert (e.g. an autoincrement key) you can use:
select * from mytable order by my_auto_increment_column DESC;
I don't think there's an equivalent on Oracle's rowid in MySQL, so if you don't have an incrementing column (could be manually incremented, but autoincrement seems more likely) then you can't do it -- in that case, just add such a column.
August 18th, 2000, 09:39 PM
Thanks,I got it.
That is : if I have no column to sort,I can't use the order feather;I can't get my data sorted by the desc order they are insterted.
I think this is a little bad.
I love MySQL.
sorry for my poor English.