3,765
回編集
差分
→update
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
;</nowiki>
== ローカル ==