SQL初心者質問スレ [無断転載禁止]©2ch.net

[0033 NAME IS NULL 2016/08/21(日) 14:33:49.32 ID:???]

recordには全idすでにある前提？

UPDATE record
SET max_gold = (SELECT MAX(gold) FROM wallet
WHERE record.user_id = wallet.user_id);

とかは？