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)