generate_fix_contact_address_owner.sql

国外的一套开源CRM

select concat('update address set address_owner_type = ''Contact'' where address_id = ',address_id,';' )
from address, contact
where (address_owner_type is null or address_owner_type = '') and address.address_owner_id = contact.contact_id;