SQL清除

joyce.sun

如果你选择关闭上传数据的避免重复数据功能和关闭所有强制性字段，如果你的数据是不完整的，你可能创建很多多余的人和地址的记录。上传已运行后，对数据库运行以下语句。
PEOPLE!

update company set comp_primarypersonid=null
where comp_primarypersonid
in (select pers_personid from person where pers_lastname is null and pers_firstname is null)

delete from phone where phon_personid in(select pers_personid from person where pers_lastname is null and pers_firstname is null)

delete from email where emai_personid in
(select pers_personid from person where pers_lastname is null and pers_firstname is null)

delete from address where addr_addressid in (select adli_addressid from address_link where adli_personid in (select pers_personid from person where pers_lastname is null and pers_firstname is null))

delete from address_link where adli_personid in (select pers_personid from person where
pers_lastname is null and pers_firstname is null)

delete from person_link where peli_Personid in (select pers_personid from person where pers_lastname is null and pers_firstname is null)

delete from person where pers_lastname is null and pers_firstname is null

ADDRESSES!

update company set comp_primaryaddressid = null where comp_primaryaddressid
in (select addr_addressid from address where addr_address1 is null)

update person set pers_primaryaddressid = null
where pers_primaryaddressid
in (select addr_addressid from address where addr_address1 is null)

delete from address_link where adli_addressid
in (select addr_addressid from address where addr_address1 is null)

delete from address where addr_address1 is null
]