08

04

2012

Mysql’de bir tabloyu yeniden sıralamak

Kategorisi : Mysql

CREATE TABLE table2 LIKE table1;

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

DROP TABLE table1;

RENAME TABLE table2 TO table1;

---