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