1. Å×ÀÌºí ±¸Á¶°¡ ´ÙÀ½°ú °°À»¶§
mysql> select * from book; +------+--------+--------+
| num | name | office |
+------+--------+--------+
| 1 | È«±æµ¿ | Çö´ë |
| 2 | ÀÓ²©Á¤ | »ï¼º |
+------+--------+--------+
2 rows in set (0.00 sec)
2. È«±æµ¿ÀÇ À̸§À» ±æµ¿È«À¸·Î ¹Ù²Ù´Â ¹æ¹ý
mysql> update book set name='±æµ¿È«' where
num=1;
Query OK, 1 row affected (0.00 sec)
mysql> select * from book; +------+--------+--------+
| num | name | office |
+------+--------+--------+
| 1 | ±æµ¿È« | Çö´ë |
| 2 | ÀÓ²©Á¤ | »ï¼º |
+------+--------+--------+
2 rows in set (0.01 sec)
|
|