mysql数据库操作修改表之修改字段(改名)
修改字段(改名):alter table 表 change [column] 原字段名 新字段名 数据类型 …
语法代码:
- -- 将name字段更改为stuname varchar(10)
- mysql> alter table stu change name stuname varchar(10);
- Query OK, 0 rows affected (0.02 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql> desc stu;
- +---------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +---------+-------------+------+-----+---------+-------+
- | id | int(11) | YES | | NULL | |
- | stuname | varchar(10) | YES | | NULL | |
- | sex | char(1) | YES | | NULL | |
- | add | varchar(20) | YES | | NULL | |
- +---------+-------------+------+-----+---------+-------+
- 4 rows in set (0.00 sec)
复制代码
|
|