SELECT ã®é›†è¨ˆçµæžœã§ãƒ†ãƒ¼ãƒ–ルを UPDATE ã™ã‚‹ SQL æ–‡ - hoge256ブãƒã‚°é »ç¹ã«ä½¿ã†ã®ã§ã™ãŒã€çµæ§‹ã„ã¤ã‚‚ã©å¿˜ã‚Œã—ã¦ã—ã¾ã†ã®ã§ã€ãƒ¡ãƒ¢ã£ã¦ãŠãã¾ã™ã€‚ 例ãˆã°ã€æ¬¡ã®ã‚ˆã†ãªå¾—点テーブル（score_data）ã¨ãƒ¦ãƒ¼ã‚¶å¾—点集計テーブル（user_total）ãŒã‚ã£ãŸã¨ã—ã¦ã€å¾—点テーブルã®é›†è¨ˆçµæžœã§ã€ãƒ¦ãƒ¼ã‚¶å¾—点集計テーブルをアップデートã™ã‚‹å ´åˆã® SQL æ–‡ã§ã™ã€‚ SELECT * FROM score_data; test_date | user_name | score ------------+-----------+------- 2008-01-01 | A | 85 2008-01-01 | B | 65 2008-01-01 | C | 90 2008-02-01 | A | 76 2008-02-01 | B | 58 2008-02-01 | C | 88 2008-03-01 | A | 92 2008-03-01 | B | 70 2008-03-01
{{#tags}}- {{label}}
{{/tags}}