ALTER TABLE `mydb`.`account` 
ADD COLUMN `bank_id` INT(11) NULL DEFAULT 0 AFTER `account_name`,
CHANGE COLUMN `idx` `idx` INT(11) NOT NULL ;

UPDATE `mydb`.`account` SET `bank_id` = '2' WHERE (`idx` = '8');
UPDATE `mydb`.`account` SET `bank_id` = '3' WHERE (`idx` = '9');
UPDATE `mydb`.`account` SET `bank_id` = '5' WHERE (`idx` = '11');
UPDATE `mydb`.`account` SET `bank_id` = '6' WHERE (`idx` = '12');
UPDATE `mydb`.`account` SET `bank_id` = '22' WHERE (`idx` = '4');
UPDATE `mydb`.`account` SET `bank_id` = '1' WHERE (`idx` = '19');

