ALTER TABLE `4dkankan_v4`.`t_agent_new` ADD COLUMN `agent_level` int NULL DEFAULT 0 COMMENT '代理等级' AFTER `status`; UPDATE t_agent_new set `agent_level` = 1 WHERE parent_id is not null;