把要自动增加的字段,设为int类型,并设为主键就可以了! 例如: CREATE TABLE guestbook ( guest varchar(20) NOT NULL default '', homepage varchar(200) NOT NULL default '', email varchar(200) NOT NULL default '', content text NOT NULL, date int(10) unsigned NOT NULL default '0', reply text NOT NULL, ip varchar(15) NOT NULL default '', id int(10) unsigned NOT NULL auto_increment,//把id设为int PRIMARY KEY (id)//设为主键,那样id就会自动递增! )
例如:
CREATE TABLE guestbook (
guest varchar(20) NOT NULL default '',
homepage varchar(200) NOT NULL default '',
email varchar(200) NOT NULL default '',
content text NOT NULL,
date int(10) unsigned NOT NULL default '0',
reply text NOT NULL,
ip varchar(15) NOT NULL default '',
id int(10) unsigned NOT NULL auto_increment,//把id设为int
PRIMARY KEY (id)//设为主键,那样id就会自动递增!
)