Besides creating a new column, copying the data into it, then deleting the old column, is there an easier way to move columns around inside phpMyAdmin?
use the CREATE TABLE statement with the SELECT option, creating a new table that looks the way you want, then delete the old one and rename the new one
that's what mysql does under the covers anyway when you run ALTER TABLE
This topic is now archived. It is frozen and cannot be changed in any way.