mysql 修改字段类型

修改字段类型：alter table 表名 modify column 字段名类型。--如alter table province_quality modify column quality float(8,2);mysql> describe province_quality ;+----------+--------------+------+-----+---------+-----

拾牙慧者

15211人浏览 · 2022-01-19 10:46:30

拾牙慧者 · 2022-01-19 10:46:30 发布

修改字段类型：

alter table 表名 modify column 字段名 类型。
--如
alter table province_quality modify column quality float(8,2);
mysql> describe province_quality ;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| province | varchar(255) | YES  |     | NULL    |       |
| quality  | float(8,2)   | YES  |     | NULL    |       |
| rtt      | float(6,2)   | YES  |     | NULL    |       |
| up       | float(6,2)   | YES  |     | NULL    |       |
| down     | float(6,2)   | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)