ºü¸¥ ¸Þ´º
  ¼¼±Ý°è»ê¼­/¿µ¼öÁõ ¹ß±Þ
  ¿ä±Ý ³³ºÎ/¹Ì³³ Á¶È¸
°øÁö ¹× ¾È³»
  °øÁö»çÇ×
  ÀÛ¾÷°øÁö
À̺¥Æ® ¹× ½Å±Ô¼­ºñ½º
  À̺¥Æ®
  ½Å±Ô ¼­ºñ½º
»ó´ã ¹× ¹®ÀÇ
  ÀÚÁÖ ¹¯´Â Áú¹®
  1:1Áú¹®°ú ´äº¯
  ¹®ÀǸÞÀÏ º¸³»±â
  °í°´»ó´ã ÀüÈ­¹øÈ£ ¾È³»
»ç¿ë¹ý ¾È³»
  ¼­ºñ½º »ç¿ë¹ý
°í°´ÀÇ ¼Ò¸®
  ĪÂùÇÕ´Ï´Ù
  Best ĪÂù»ç¿ø
  Á¦¾ÈÇÕ´Ï´Ù
  Á¦¾È ¹Ý¿µ ³»¿ª
BlueCGI ºÒ·®»ç¿ëÀÚ ½Å°í
ºí·çÀ¥ ÄÝ¹é ¼­ºñ½º
 
  
MySQL DB MS-SQL DB
 
Á¦¸ñ  DATA ¼öÁ¤Çϱâ (UPDATE)
 

*

 µ¥ÀÌÅÍ ¼öÁ¤Çϱâ ( 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) 

 

 
 


Á¤º¸º¸È£¾ÈÀüÁø´ÜÇÊÁõ ȹµæ Çѱ¹ÀÎÅͳÝÁøÈï¿ø °øÀÎ µµ¸ÞÀÎ µî·Ï´ëÇàÀÚ tucows kt idc sk idc
 
ºí·çÀ¥
¢ßÀ¯´ÏÆÄÀÌ ¼­¿ïƯº°½Ã ¼ºµ¿±¸ ±¤³ª·ç·Î 144, ´õ ½ºÆäÀ̽º Ÿ¿ö 7Ãþ, 13Ãþ (º»Á¡)
´ëÇ¥ÀÌ»ç : ÀÓ¼ºÈ£ »ç¾÷ÀÚµî·ÏÁõ¹øÈ£ : 106-81-85951 Åë½ÅÆǸž÷ ½Å°í¹øÈ£ : °­³² 3315È£ °³ÀÎÁ¤º¸º¸È£Ã¥ÀÓÀÚ : ÀÌÃæÈñ
Copyright¨Ï Blueweb All rights Reserved.