Discuz! info: MySQL Query Error
User: admin
Time: 2008-5-27 3:44pm
Script: /install_stock.php
SQL: CREATE TABLE [Table]ai (
id mediumint(8) unsigned NOT NULL auto_increment,
ainame varchar(50) NOT NULL default '',
cash double NOT NULL default '0',
fund double NOT NULL default '0',
stocktypenum int(10) NOT NULL default '0',
todaybuy int(10) NOT NULL default '0',
todaysale int(10) NOT NULL default '0',
totalbuy double NOT NULL default '0',
totalsale double NOT NULL default '0',
aid int(10) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM DEFAULT CHARSET=GBK AUTO_INCREMENT=3 ;
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=3' at line 13
Errno.: 1064
运行install_stock.php。就出现上面的情况,能告知是什么原因吗???急急急 |