Question

mysql中如何对已设置好的数据库进行字段属性的修改

mysql中如何对已设置好的数据库进行字段属性的修改

Answer 1

describe employee
-> ;
+--------------+-------------+------+-----+---------+----------------+
| 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)