Advertisement
Guest User

SQL to Move Person Attribute to Address Field

a guest
Nov 21st, 2015
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. UPDATE `person_attribute`, `person_address` SET `person_address`.`address2` = `person_attribute`.`value`, `person_attribute`.`voided` = 1, `person_attribute`.`voided_by` = 1, `person_attribute`.`date_voided` = NOW(), `person_attribute`.`void_reason` = "merged to address2 field", `person_address`.`changed_by` = 1, `person_address`.`date_changed` = NOW() WHERE `person_attribute_type_id` = 14 AND `person_attribute`.`voided` = 0 AND `person_address`.`voided` = 0 AND `person_attribute`.`person_id` = `person_address`.`person_id` AND `address2` IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement