Mysql创建user表时出错,代码如下:
CREATE TABLE user(
id int auto_increment NOT NULL,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL,
CONSTRAINT PK_YX_CMS_ARTICLETEMPLATE PRIMARY KEY CLUSTERED
(
uid ASC
)
)
请为改如何将uid设为主键
CREATE TABLE user(
id int auto_increment NOT NULL,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL,
CONSTRAINT PK_YX_CMS_ARTICLETEMPLATE PRIMARY KEY CLUSTERED
(
uid ASC
)
)
请为改如何将uid设为主键
id int auto_increment NOT NULL primary key,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL
) MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
id int auto_increment NOT NULL primary key,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL
)
CREATE TABLE user(
id int auto_increment NOT NULL,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL,
PRIMARY KEY(id)
)
CREATE TABLE user(
id int auto_increment NOT NULL,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL,
PRIMARY KEY(id,uid)
)
id int auto_increment NOT NULL,
uid int NOT NULL ,
age int NULL,
name char(10) NULL,
address varchar(50) NULL,
PRIMARY KEY(id,uid)
)