[code:1]mysql> CREATE TABLE nuke_contactbook (
-> uid int(11) default NULL,
-> contactid int(11) NOT NULL auto_increment,
-> firstname varchar(50) default NULL,
-> lastname varchar(50) default NULL,
-> email varchar(255) default NULL,
-> company varchar(255) default NULL,
-> homeaddress varchar(255) default NULL,
-> city varchar(80) default NULL,
-> homephone varchar(255) default NULL,
-> workphone varchar(255) default NULL,
-> homepage varchar(255) default NULL,
-> IM varchar(255) default NULL,
-> events text,
-> reminders int(11) default NULL,
-> notes text,
-> PRIMARY KEY(contactid),
-> KEY uid (uid),
-> KEY contactid (contactid)
-> ) TYPE=MyISAM;
ERROR 1064: You have an error in your SQL syntax near 'events text,
reminders int(11) default NULL,
notes text,
PRIMARY KEY(conta' at line 14
mysql>[/code:1]
这个问题怎么解决呢?这是我在调试6.5版本时遇到的,按道理应该没有问题的啊!是不是? |