update文を使う。以下は自作のumamusumeというテーブルの、ある行の列の値を修正した例。
mysql> select * from umamusume; +------+------------------+------------+------------+---------------------+ | no | name | prizemoney | seiyu | dummydate | +------+------------------+------------+------------+---------------------+ | 8 | ウオッカ | 13.0487 | 大橋彩香 | 2031-02-03 00:00:00 | | 30 | ライスシャワー | 6.6686 | 石見舞菜香 | 2032-11-12 00:00:00 | | 45 | スーパークリーク | 5.561 | 優木かな | 2033-11-12 00:00:00 | | 58 | メイショウドトウ | NULL | 和多田美咲 | NULL | +------+------------------+------------+------------+---------------------+ 4 rows in set (0.00 sec) mysql> update umamusume set prizemoney = 9.2133 where no = 58; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from umamusume; +------+------------------+------------+------------+---------------------+ | no | name | prizemoney | seiyu | dummydate | +------+------------------+------------+------------+---------------------+ | 8 | ウオッカ | 13.0487 | 大橋彩香 | 2031-02-03 00:00:00 | | 30 | ライスシャワー | 6.6686 | 石見舞菜香 | 2032-11-12 00:00:00 | | 45 | スーパークリーク | 5.561 | 優木かな | 2033-11-12 00:00:00 | | 58 | メイショウドトウ | 9.2133 | 和多田美咲 | NULL | +------+------------------+------------+------------+---------------------+ 4 rows in set (0.00 sec) mysql> update umamusume set -> prizemoney = 9.2133, -> dummydate = '2033/12/31' -> where no = 58; Query OK, 1 row affected, 1 warning (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql> select * from umamusume; +------+------------------+------------+------------+---------------------+ | no | name | prizemoney | seiyu | dummydate | +------+------------------+------------+------------+---------------------+ | 8 | ウオッカ | 13.0487 | 大橋彩香 | 2031-02-03 00:00:00 | | 30 | ライスシャワー | 6.6686 | 石見舞菜香 | 2032-11-12 00:00:00 | | 45 | スーパークリーク | 5.561 | 優木かな | 2033-11-12 00:00:00 | | 58 | メイショウドトウ | 9.2133 | 和多田美咲 | 2033-12-31 00:00:00 | +------+------------------+------------+------------+---------------------+ 4 rows in set (0.00 sec)