1、修改A表pick_quantity 字段添加默认值为0: ALTER TABLE `A` MODIFY COLUMN `pick_quantity` double default 0;
2、修改A表添加 username 字段:alter table A add username varchar(10) not Null;
3、修改 A表 设置 pick_quantity 字段为0:update `A` t set pick_quantity =0 where pick_quantity is null;