求解 MySQL #1064错误

来源：百度知道 编辑：UC知道 时间：2024/09/20 21:09:37
MySQL said:

#1064 - 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 '0',
`username` char(15) NOT NULL default '',
`uid` mediumint(8) unsigned N' at line 2

===========以下是出错代码的上下文

--
-- Table structure for table `cdb_activityapplies`
--

DROP TABLE IF EXISTS `cdb_activityapplies`;
CREATE TABLE `cdb_activityapplies` (
`applyid` int(10) unsigned NOT NULL auto_increment,
`tid` mediumint(8) unsigned NOT NULL default '0',
`username` char(15) NOT NULL default '',
`uid` mediumint(8) unsigned NOT NULL default '0',
`message` char(200) NOT NULL default '',
`verified` tinyint(1) NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`payment` mediumint(8) NOT NULL default '0',
`contact

*******************
你的代码我试验了没有错误，怀疑你执行的时候不下心导致了sql【错位】造成的。以下是正常的实施log请参照：
*******************
mysql> show tables;
+------------------------+
| Tables_in_test20090503 |
+------------------------+
| cdb_activityapplies |
| t1 |
+------------------------+
2 rows in set (0.00 sec)

mysql> drop table cdb_activityapplies;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE IF EXISTS `cdb_activityapplies`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `cdb_activityapplies` (
-> `applyid` int(10) unsigned NOT NULL auto_increment,
-> `tid` mediumint(8) unsigned NOT NULL default '0',
-> `username` char(15) NOT NULL default '',
-> `uid` mediumint(8) unsigned NOT NULL default '0',
-> `message` char(200) NOT NULL default '',
-> `ver