#删除重复数据 delete from tlk_securityMan where id not in ( select t.max_id from (select max(id) as max_id from tlk_securityMan group by domainid,item_documentid) as t ); #给身份证和组织id添加约束名为onlyOneSecurityMan的联合唯一约束 alter table tlk_securityMan add constraint onlyOneSecurityMan UNIQUE(item_documentid,domainid);