mysql添加修改字段

ALTER TABLE `uc_organization` ADD COLUMN `agent_id` VARCHAR(50) NOT NULL DEFAULT 0 COMMENT 'sqlserver代理商id';
ALTER TABLE `uc_organization` ADD COLUMN `agent_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'sqlserver代理商名称';

ALTER TABLE uc_organization CHANGE COLUMN agent_id agent_id VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'sqlserver代理商id';