Resort (reorder) table data

Posted by Dave Jarvis on Stack Overflow See other posts from Stack Overflow or by Dave Jarvis
Published on 2010-05-26T22:51:22Z Indexed on 2010/05/26 23:01 UTC
Read the original article Hit count: 224

CREATE TABLE table2 LIKE table1;

INSERT INTO table2
  SELECT * FROM table1 ORDER BY by name;

DROP TABLE table1;

RENAME TABLE table2 TO table1;

© Stack Overflow or respective owner