reordering columns works

[sdowney1]

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

for example

ALTER TABLE bookdata CHANGE locnumber locnumber varchar(100) AFTER ts

 

I found you can do this. Looking into it people on other forums said you cant. But I found you can.

so has this been implemented  recently?

[fenway]

In MySQL 3.22 or later, to add a column at a specific position within a table row, use FIRST or AFTER col_name. The default is to add the column last. From MySQL 4.0.1 on, you can also use FIRST and AFTER in CHANGE or MODIFY operations to reorder columns within a table.