Mysql修改表字段类型

原创

说文科技 2022-01-28 09:32:04 ©著作权

©著作权归作者所有：来自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)