CREATE TABLE quest_request_res ( agegrp tinyint(2) DEFAULT '0' NOT NULL, sex text NOT NULL, income int(8) DEFAULT '0' NOT NULL, pepnum tinyint(2) DEFAULT '0' NOT NULL, address text NOT NULL, edu text NOT NULL, youth tinyint(1) DEFAULT '0' NOT NULL, reader tinyint(1) DEFAULT '0' NOT NULL, other tinyint(1) DEFAULT '0' NOT NULL, shenzhen tinyint(1) DEFAULT '0' NOT NULL, ress tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (agegrp) );就是在 copy到htdoc目录下时报错,数据库究竟应该放在什么位置才能执行?
agegrp tinyint(2) DEFAULT '0' NOT NULL,
sex text NOT NULL,
income int(8) DEFAULT '0' NOT NULL,
pepnum tinyint(2) DEFAULT '0' NOT NULL,
address text NOT NULL,
edu text NOT NULL,
youth tinyint(1) DEFAULT '0' NOT NULL,
reader tinyint(1) DEFAULT '0' NOT NULL,
other tinyint(1) DEFAULT '0' NOT NULL,
shenzhen tinyint(1) DEFAULT '0' NOT NULL,
ress tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (agegrp)
);就是在 copy到htdoc目录下时报错,数据库究竟应该放在什么位置才能执行?
我不明白了,
我想也就是你说出错的原因了
primary key must be unique ????try unique it or autoincrease it and tell us the result ..