Mysql修改表字段类型
原创
©著作权归作者所有:来自51CTO博客作者说文科技的原创作品,请联系作者获取转载授权,否则将追究法律责任
Mysql修改表字段类型
mysql> desc orders ;
+
| Field | Type | Null | Key | Default | Extra |
+
| shipaddress | varchar(20) | YES | MUL | NULL | |
| shipcity | varchar(20) | YES | | NULL | |
+
2 rows in set (0.13 sec)
mysql> alter table orders modify column shipaddress int(20) ;
Query OK, 0 rows affected (0.85 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc orders ;
+
| Field | Type | Null | Key | Default | Extra |
+
| shipaddress | int(20) | YES | MUL | NULL | |
| shipcity | varchar(20) | YES | | NULL | |
+
2 rows in set (0.00 sec)