¿ù°£ Àα⠰Խù°

°Ô½Ã¹° 58°Ç
   
MYSQL Å×À̺í ŸÀÔ¼öÁ¤
±Û¾´ÀÌ : ÃÖ°í°ü¸®ÀÚ ³¯Â¥ : 2010-06-30 (¼ö) 12:46 Á¶È¸ : 9008
±ÛÁÖ¼Ò :
                          

mysql> desc TB_DOMAIN;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| no          | int(11)     |      | PRI | NULL    | auto_increment |
| ip          | varchar(32) |      |     |         |                |
| domain      | varchar(60) | YES  |     | NULL    |                |
| create_date | varchar(32) |      |     |         |                |
| update_date | varchar(32) |      |     |         |                |
| status      | varchar(10) | YES  |     | no      |                |
| reason      | varchar(60) | YES  |     | NULL    |                |
| memo        | varchar(60) |      |     |         |                |
+-------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)


mysql> alter table TB_DOMAIN change column domain  domain varchar(80);
Query OK, 2495 rows affected (0.02 sec)
Records: 2495  Duplicates: 0  Warnings: 0

mysql> desc TB_DOMAIN;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| no          | int(11)     |      | PRI | NULL    | auto_increment |
| ip          | varchar(32) |      |     |         |                |
| domain      | varchar(80) | YES  |     | NULL    |                |
| create_date | varchar(32) |      |     |         |                |
| update_date | varchar(32) |      |     |         |                |
| status      | varchar(10) | YES  |     | no      |                |
| reason      | varchar(60) | YES  |     | NULL    |                |
| memo        | varchar(60) |      |     |         |                |
+-------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)


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

 



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