Sql语句-日常小记

更新

1、通过另一个表更新表数据

UPDATE party_member_info pmi
SET 
 created_at = pmit.created_at,
 created_by = pmit.created_by,
 updated_by = pmit.updated_by,
 updated_at = pmit.updated_at,
 description = pmit.description,
 is_deleted = pmit.is_deleted,
 join_time = pmit.join_time,
 party_position = pmit.party_position,
 party_dues_standard = pmit.party_dues_standard,
 dues_time = pmit.dues_time,
 party_branch = pmit.party_branch,
 join_branch_time = pmit.join_branch_time
FROM
    party_member_info_temp pmit
WHERE
    pmit.id_ = 944157486359777281 AND pmi.id_= 944157486359777281