Tag Info

New answers tagged


You can create a new table like the old one and insert the values in a different order, for example: CREATE TABLE new_table like old_table; INSERT INTO new_table (date, name) SELECT date, name FROM old_table ORDER BY date ASC, id DESC Change the ORDER BY to whatever suits to you- I have ordered by date so it doesn't trust that the original data was ...

Top 50 recent answers are included