ALTER TABLE `cdb_user_group_org_mapping` add (
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '数据有效性 0 无效 1 有效',
`create_time` varchar(80) DEFAULT NULL COMMENT '创建时间',
`modify_time` varchar(80) DEFAULT NULL COMMENT '修改时间';
)
UPDATE cdb_user_group_org_mapping1 SET status = 1, create_time = "2019/10/28 17:18:25", modify_time = "2019/10/28 17:18:25" WHERE id > 0
create table cdb_user_group_org_mapping1 like cdb_user_group_org_mapping;
INSERT INTO cdb_user_group_org_mapping1 SELECT * FROM cdb_user_group_org_mapping;
1 批量update
UPDATE
dw_cdb_course_dim_mg_mapping a,
dw_cdb_org_info b
SET a.manage_group_id=b.id
WHERE
a.manage_group_name is not null
and
a.manage_group_name = b.org_name;