=== update ===
<nowiki> =# update
others as t1
set
name = t2.name, yomi = t2.yomi, client_name = t2.nusi, line = t2.each_order, memo = t2.memo, generation = t2.generation, created_at = t2.created_at, updated_at = t2.updated_at
from
jq_clients as t2;
UPDATE 3066</nowiki>
<nowiki>=# UPDATE others SET
name = (SELECT name FROM jq_clients),
yomi = (SELECT yomi FROM jq_clients),
client_name = (SELECT nusi FROM jq_clients),
line = (SELECT each_order FROM jq_clients),
memo = (SELECT memo FROM jq_clients),
generation = (SELECT generation FROM jq_clients),
created_at = (SELECT created_at FROM jq_clients),
updated_at = (SELECT updated_at FROM jq_clients)
;</nowiki>
<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
FROM (SELECT name, yomi, nusi, each_order, memo, generation, created_at, updated_at FROM jq_clients) atab
;UPDATE 3066</nowiki>
== ローカル ==