3,765
回編集
差分
→親テーブルie_id 子テーブルie_id 差分削除
% diff aa_clients_id_ie_id.csv bb_clients_old_ie_id.csv > diff.csv
=== insert ===
=== update ===
[[#top]]
<nowiki>=# UPDATE others set
name = atab.name, yomi = atab.yomi, client_name = atab.nusi, line = atab.each_order, memo = atab.memo, generation = atab.generation, created_at = atab.created_at, updated_at = atab.updated_at