[摘要]+--------+-------------+------+-----+---------+-------+5 rows in set (0.00 sec)在表的指定字段之后增加字段ALTER T...
+--------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
在表的指定字段之后增加字段
ALTER TABLE table_name ADD 属性名 属性类型 AFTER 属性名
mysql> alter table tab_dept add comm varchar(20) after dname;
Query OK, 0 rows affected (0.31 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc tab_dept;
+--------+-------------+------+-----+---------+-------+
关键词：mysql学习之表的基本设置的代码分享