[摘要]+--------+-------------+------+-----+---------+-------+5 rows in set (0.00 sec)字段修改-修改字段数据类型ALTER T...
+--------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
字段修改-修改字段数据类型
ALTER TABLE table_name MODIFY 属性名 数据类型
mysql> alter table tab_dept modify descri int;
Query OK, 0 rows affected (0.45 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc tab_dept;
+--------+-------------+------+-----+---------+-------+
关键词：mysql学习之表的基本设置的代码分享