pt-online-schema-change –user=root –password=root –defaults-file=/home/mysql/my6306.cnf –charset=utf8 –alter “add column trans_status_1 tinyint(3) NULL DEFAULT 1 COMMENT ‘1 未转让, 2 待转让, 3 转让中, 4 部分转让, 5 已转让’ AFTER repay_status,ADD COLUMN xprj_order_id_1 int(11) NULL DEFAULT 0 COMMENT ‘对应的新 计划的订单id'” D=test,t=testr –exec –no-drop-old-table
