mysql中如何对已设置好的数据库进行字段属性的修改
发布网友
发布时间：2022-04-23 10:11
共1个回答
热心网友
时间：2022-04-08 05:56
-> ;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| employeeID | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(80) | YES | MUL | NULL | |
| job | varchar(30) | YES | | NULL | |
| departmentID | int(11) | NO | | | |
+--------------+-------------+------+-----+---------+----------------
alter table employee change column name xm varchar(70)
