¿ù°£ Àα⠰Խù°

°Ô½Ã¹° 58°Ç
   
[MYSQL] ÇʵåÃß°¡/»èÁ¦
±Û¾´ÀÌ : ÃÖ°í°ü¸®ÀÚ ³¯Â¥ : 2010-12-20 (¿ù) 15:06 Á¶È¸ : 9704
±ÛÁÖ¼Ò :
                          

- Ãß°¡
Alter Table tableName Add fieldName fieldtype;

- »èÁ¦
Alter Table tableName Drop fieldName;


¿¹Á¦)
mysql> alter table SRC_IP add ttl int(3);

Query OK, 197662 rows affected (2.85 sec)
Records: 197662  Duplicates: 0  Warnings: 0


mysql> alter table SRC_IP add ping_time int(10);
Query OK, 197662 rows affected (2.84 sec)
Records: 197662  Duplicates: 0  Warnings: 0


À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
   

 



 
»çÀÌÆ®¸í : ¸ðÁö¸®³× | ´ëÇ¥ : ÀÌ°æÇö | °³ÀÎÄ¿¹Â´ÏƼ : ·©Å°´åÄÄ ¿î¿µÃ¼Á¦(OS) | °æ±âµµ ¼º³²½Ã ºÐ´ç±¸ | ÀüÀÚ¿ìÆí : mojily°ñ¹ðÀÌchonnom.com Copyright ¨Ï www.chonnom.com www.kyunghyun.net www.mojily.net. All rights reserved.