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?
Thanks!
| SitePoint Sponsor |




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?
Thanks!
Convert your dollars into silver coins. www.convert2silver.com


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
Bookmarks