Uncategorized / Change field order  

0.0% 100%
0 pages 19 questions
No questions

ALTER TABLE ... MODIFY is preferable even though ALTER TABLE ... CHANGE works. The reason is that the latter has additional feature of changing column name (you may accidentally change column name)
alter table page change column catg catg varchar(25) after id; alter table page modify subcatg varchar(25) after catg;