mySQL 用MODIFY修改数据报错:check the manual that corresponds to your MySQL server versi
小西瓜籽 2016-08-26 12:04:10 mySQL 用MODIFY修改数据报错:
代码语句: ALTER TABLE employees
MODIFY(last_name VARCHAR(30));
报错信息:
check the manual that corresponds to your MySQL server version for the right syntax to use near '(last_name VARCHAR(30))' at line 2
employees表是个只有列名和数据类型的空表
----------------+--------------+------+-----+---------+----------------+
Field | Type | Null | Key | Default | Extra |
----------------+--------------+------+-----+---------+----------------+
employee_id | int(6) | NO | PRI | NULL | auto_increment |
first_name | varchar(20) | YES | | NULL | |
last_name | varchar(25) | YES | | NULL | |
email | varchar(25) | YES | | NULL | |
phone_number | varchar(20) | YES | | NULL | |
job_id | varchar(10) | YES | MUL | NULL | |
salary | double(10,2) | YES | | NULL | |
commission_pct | double(4,2) | YES | | NULL | |
manager_id | int(6) | YES | | NULL | |
department_id | int(4) | YES | MUL | NULL | |
----------------+--------------+------+-----+---------+----------------+