Discuz! info: MySQL Query Error
User: 红星
Time: 2006-4-21 11:52am
Script: /club/install_lovewall.php
SQL:
CREATE TABLE cdb_lovewall (
id bigint(20) NOT NULL auto_increment,
lovesay tinytext NOT NULL,
uid int(11) NOT NULL default '0',
uname varchar(16) NOT NULL default '',
backcolor varchar(6) NOT NULL default '',
postop smallint(3) NOT NULL default '0',
posleft smallint(3) NOT NULL default '0',
lovetime bigint(20) NOT NULL default '0',
PRIMARY KEY (id),
KEY id (id),
KEY uid (uid),
KEY lovetime (lovetime)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
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 'DEFAULT CHARSET=gbk AUTO_INCREMENT=1' at line 14
Errno.: 1064
Similar error report has beed dispatched to administrator before.
请大虾帮忙解决! |