mysql - SQL - UPDATE TABLE and ORDER BY? -
so have unordered table movement has columns timestamp,x,and y. want order timestamp, , change , save table have rows ordered timestamp.
i wanted use update table i'm unsure on how query look... example, have this:
update movement set ????? order timestamp; i don't want set anything, want change order of table. need query i'm going write, fact table large , need break things in steps performance isn't terrible later. how this? found this post addressed similar question, wondering if there way rather use table, because said, table large(millions of rows) , recopying table take long time.
tables don't inherently have order; don't have update them particular order.
what choose order of select table. can in order choose!
example:
select * movement order timestamp; but somewhere else maybe want to:
select * movement order timestamp descending;
Comments
Post a Comment