查人人中国名人网环保部举报平台:Discuz! info: MySQL Query Error帮帮我
来源：百度文库 编辑：查人人中国名人网 时间：2024/05/06 07:55:21
Script:
SQL: CREATE TABLE cdb_memberfields ( uid mediumint(8) unsigned NOT NULL default '0', nickname varchar(30) NOT NULL default '', site varchar(75) NOT NULL default '', alipay varchar(50) NOT NULL default '', icq varchar(12) NOT NULL default '', qq varchar(12) NOT NULL default '', varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao varchar(40) NOT NULL default '', location varchar(30) NOT NULL default '', customstatus varchar(30) NOT NULL default '', medals varchar(255) NOT NULL default '', avatar varchar(255) NOT NULL default '', avatarwidth tinyint(3) unsigned NOT NULL default '0', avatarheight tinyint(3) unsigned NOT NULL default '0', bio text NOT NULL, signature text NOT NULL, sightml text NOT NULL, ignorepm text NOT NULL, groupterms text NOT NULL, authstr varchar(20) NOT NULL default '', PRIMARY KEY (uid)) ENGINE=MYISAM DEFAULT CHARSET=gbk
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao v' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before.
这个是什么意思啊?????最好能把解决的方案也给我谢谢!!!!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao v' at line 1
SQL的语法错误,应该是'varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao v' 这些地方有错误.
应该改为
CREATE TABLE cdb_memberfields
( uid mediumint(8) unsigned NOT NULL default '0',
nickname varchar(30) NOT NULL default '',
site varchar(75) NOT NULL default '',
alipay varchar(50) NOT NULL default '',
icq varchar(12) NOT NULL default '',
qq varchar(12) NOT NULL default '',
xxxx varchar(40) NOT NULL default '',
~~~~这里需要一个表中字段名,但是我不知道应该是什么
msn varchar(40) NOT NULL default '',
taobao varchar(40) NOT NULL default '',
location varchar(30) NOT NULL default '',
customstatus varchar(30) NOT NULL default '',
medals varchar(255) NOT NULL default '',
avatar varchar(255) NOT NULL default '',
avatarwidth tinyint(3) unsigned NOT NULL default '0',
avatarheight tinyint(3) unsigned NOT NULL default '0',
bio text NOT NULL,
signature text NOT NULL,
sightml text NOT NULL,
ignorepm text NOT NULL,
groupterms text NOT NULL,
authstr varchar(20) NOT NULL default '',
PRIMARY KEY (uid))
ENGINE=MYISAM DEFAULT CHARSET=gbk
这实际上是一个SQL的语句,字段少了个名字而已,你添加个名字试试,不行加我QQ188925047
字段似乎不匹配