+++ ȨÁ¦ÀÛ ¹ÙÀ̺í +++
ȨÁ¦ÀÛ ¹ÙÀ̺í ÀÌ »çÀÌÆ®´Â ÀÌ¿µÂù´ÔÀÇ »çÀÌÆ®¸¦ º¹¿øÇÑ °ÍÀÔ´Ï´Ù.
Untitled Document
Html
Dhtml
Css
Php
Asp
Cgi
Java Script
Java Applet
Multimedia
Win Tip
Mysql - update
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)

         
Update : 2000/08/01 [µ¹¾Æ°¡±â]