Discuz! info: MySQL Query Error

来源：百度知道 编辑：UC知道 时间：2024/06/05 20:24:45
Time: 2006-8-20 7:14am
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 '',

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

说你的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 '',

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