ALTER TABLE tablename MODIFY COLUMN TYPE(length) AFTER x;