Discuz! info: MySQL Query Error
User: admin
Time: 2007-5-2 4:05pm
Script: /bbs1/admincp.php
SQL: CREATE TABLE [Table]dingpiao ( id int(10) unsigned NOT NULL auto_increment, type int(1) unsigned NOT NULL default '0', peo_type varchar(25) NOT NULL default '0', cangwei int(1) unsigned NOT NULL default '0', gocity varchar(50) NOT NULL default '0', formcity varchar(50) NOT NULL default '0', gotime varchar(30) NOT NULL default '0', formtime varchar(30) NOT NULL default '0', bbsname varchar(50) NOT NULL default '', username varchar(50) NOT NULL default '', buy int(1) NOT NULL default '0', key varchar(255) NOT NULL default '', phone varchar(50) NOT NULL default '', qq varchar(30) NOT NULL default '', gaoji int(1) unsigned NOT NULL default '0', chuli int(1) unsigned NOT NULL default '0', PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=98
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(255) NOT NULL default '', phone varchar(50) NOT NULL de
Errno.: 1064 |