ALTER TABLE followers ADD COLUMN `acct_migr` char(64) NOT NULL; UPDATE followers SET `acct_migr` = `acct`; ALTER TABLE followers DROP COLUMN `acct`; ALTER TABLE followers ADD COLUMN `acct` char(64) NOT NULL; UPDATE followers SET `acct` = `acct_migr`; ALTER TABLE followers DROP COLUMN `acct_migr`;