原帖由 zangyd 于 2006-9-20 06:46 发表 
升级错误,MySQL 提示: 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' at line 1 
怎么弄? ...   
DROP TABLE IF EXISTS cdb_paymoney; 
CREATE TABLE `cdb_paymoney` ( 
  `uid` mediumint(8) unsigned NOT NULL auto_increment, 
  `username` char(15) NOT NULL default '', 
  `basic` int(10) unsigned NOT NULL default '0', 
  `online` int(10) unsigned NOT NULL default '0', 
  `notonlinetime` int(10) unsigned NOT NULL default '0', 
  `salarydelete` int(10) unsigned NOT NULL default '0', 
  `salarymove` int(10) unsigned NOT NULL default '0', 
  `salaryhighlight` int(10) unsigned NOT NULL default '0', 
  `salaryclose` int(10) unsigned NOT NULL default '0', 
  `salarystick` int(10) unsigned NOT NULL default '0', 
  `salarydigest` int(10) unsigned NOT NULL default '0', 
  `salarytype` int(10) unsigned NOT NULL default '0', 
  `salaryedit` int(10) unsigned NOT NULL default '0', 
  `salarypostdel` int(10) unsigned NOT NULL default '0', 
  `dateline`  int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`uid`), 
  UNIQUE KEY `username` (`username`) 
) ENGINE=MyISAM; |