创建表的SQL语句: CREATE TABLE category ( id int(12) NOT NULL auto_increment, turn int(10) NOT NULL, en_name varchar(200) NOT NULL, name varchar(200) NOT NULL, description varchar(200), parent_id int(10), product_num int(10) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 出现的错误: ERROR 1075 (42000): Incorrect table definition; there can be only one auto colum n and it must be defined as a key
我记得在linux上创建的时候一点问题也没有,为什么windows上都是问题呢!谢谢回答!
CREATE TABLE category ( id INT(12) NOT NULL AUTO_INCREMENT, turn INT(10) NOT NULL, en_name VARCHAR(200) NOT NULL, NAME VARCHAR(200) NOT NULL, description VARCHAR(200), parent_id INT(10), product_num INT(10), KEY(id) ) ENGINE=INNODB DEFAULT CHARSET=utf8; 已经提示,it must be defined as a key
>id int,
>name varchar(30)
>);
create table tt(id int,bh varchar(30))
CREATE TABLE category (
id int(12) NOT NULL auto_increment,
turn int(10) NOT NULL,
en_name varchar(200) NOT NULL,
name varchar(200) NOT NULL,
description varchar(200),
parent_id int(10),
product_num int(10)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
出现的错误:
ERROR 1075 (42000): Incorrect table definition; there can be only one auto colum
n and it must be defined as a key
id INT(12) NOT NULL AUTO_INCREMENT,
turn INT(10) NOT NULL,
en_name VARCHAR(200) NOT NULL,
NAME VARCHAR(200) NOT NULL,
description VARCHAR(200),
parent_id INT(10),
product_num INT(10),
KEY(id)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
已经提示,it must be defined as a key