create table Players(
playerid int default 0 not null auto_increment, #想设置为从0开始的自增1的字段
accountnum varchar(10) not null, #不可重复性
nickname varchar(16)not null,
age int default 0,
sex int default 0,
constraint PK_Players primary key (playerid),
constraint IX_Players unique (accountnum)
);然后如果还想在此外加一个字段该如何操作,是不是:alter table Players add 字段名 int;即可?
playerid int default 0 not null auto_increment, #想设置为从0开始的自增1的字段
accountnum varchar(10) not null, #不可重复性
nickname varchar(16)not null,
age int default 0,
sex int default 0,
constraint PK_Players primary key (playerid),
constraint IX_Players unique (accountnum)
);然后如果还想在此外加一个字段该如何操作,是不是:alter table Players add 字段名 int;即可?
create table Players(
playerid int not null auto_increment, #想设置为从0开始的自增1的字段
accountnum varchar(10) not null, #不可重复性
nickname varchar(16)not null,
age int default 0,
sex int default 0,
constraint PK_Players primary key (playerid),
constraint IX_Players unique (accountnum)
) AUTO_INCREMENT=1;
[align=center]==== 思想重于技巧 ====
[/align]