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

Popular posts from this blog

javascript - Bootstrap Popover: iOS Safari strange behaviour -

Magento/PHP - Get phones on all members in a customer group -

session - Logging Out Using PHP -