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