* |
µ¥ÀÌÅÍ ¼öÁ¤Çϱâ
( UPDATE ) |
|
|
ÀÌ¹Ì Á¸ÀçÇÏ´Â µ¥ÀÌÅ͸¦ ¼öÁ¤Çϰųª, ƯÁ¤ÇʵåÀÇ °ªÀ» º¯°æÇÒ ¶§¿¡ »ç¿ëÇÕ´Ï´Ù.
|
|
|
UPDATE Å×À̺í¸í SET Çʵå¸í=Çʵ尪 ¶Ç´Â »ê¼ú½Ä [WHERE °Ë»öÁ¶°Ç] | | |
|
|
where ÀýÀ» ÁÖÁö ¾ÊÀ¸¸é ¸ðµç µ¥ÀÌÅÍ°¡ µ¿ÀÏÇÏ°Ô ¼öÁ¤ÀÌ µÇ´Ï ¹Ýµå½Ã À¯ÀÇÇϽñ⠹ٶø´Ï´Ù. |
|
¿¹ |
num ÇʵåÀÇ °ªÀÌ nullÀÎ DATA°ªÀ» 0À¸·Î º¯°æÇϱâ
|
|
|
mysql> update test set num=0 where num is null;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from test;
+--------+------+
| name | num |
+--------+------+
| ºí·çÀ¥ | 1 |
| bluewe| 0 |
| ºí·ç | 3 |
| web | 3 |
+--------+------+
2 rows in set (0.00 sec)
| | |
|
¿¹ |
num ÇʵåÀÇ °ªÀ» ¸ðµÎ 1¾¿ Áõ°¡½ÃÅ°±â
|
|
|
mysql> update test set num=num+1; Query OK, 4 row affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> select * from test;
+--------+------+
| name | num |
+--------+------+
| ºí·çÀ¥ | 2 |
| bluewe | 1 |
| ºí·ç | 4 |
| web | 4 |
+--------+------+
4 rows in set (0.00 sec)
| | |
|