这个本身属于MySQL的基本语法,我这里给出一个例子而已。
mysql> -- 测试数据库在指定位置增加字段mysql> drop table if exists t;Query OK, 0 rows affected (0.06 sec)mysql> create table t(age int,address varchar(50));Query OK, 0 rows affected (0.06 sec)mysql> desc t;+---------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+-------------+------+-----+---------+-------+| age | int(11) | YES | | NULL | || address | varchar(50) | YES | | NULL | |+---------+-------------+------+-----+---------+-------+2 rows in set (0.02 sec)mysql> alter table t add column name varchar(20) after age;Query OK, 0 rows affected (0.16 sec)Records: 0 Duplicates: 0 Warnings: 0mysql> desc t;+---------+-------------+------+-----+---------+