mysql数据库操作修改表之添加字段
语法代码:
- mysql> alter table stu add `add` varchar(20); -- 默认添加字段放在最后
- Query OK, 0 rows affected (0.05 sec)
- mysql> alter table stu add sex char(1) after name; -- 在name之后添加sex字段
- Query OK, 0 rows affected (0.00 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql> alter table stu add age int first; -- age放在最前面
- Query OK, 0 rows affected (0.00 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql> desc stu;
- +-------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+-------------+------+-----+---------+-------+
- | age | int(11) | YES | | NULL | |
- | id | int(11) | YES | | NULL | |
- | name | varchar(20) | YES | | NULL | |
- | sex | char(1) | YES | | NULL | |
- | add | varchar(20) | YES | | NULL | |
- +-------+-------------+------+-----+---------+-------+
- 5 rows in set (0.00 sec)
复制代码
|
|