错误
您的 SQL 查询可能有错。如果可能的话,以下会列出 MySQL 服务器的错误输出,这可能对您解决问题有一定的帮助作用。
ERROR: 引号不配对 @ 824
STR: `
SQL: -- --------------------------------------------------------
--
-- ?�?ṹ `uchome_udisk`
--
CREATE TABLE `uchome_udisk` (
`albumid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`albumname` varchar(50) NOT NULL DEFAULT '',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` varchar(15) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0',
`picnum` smallint(6) unsigned NOT NULL DEFAULT '0',
`pic` varchar(60) NOT NULL DEFAULT '',
`picflag` tinyint(1) NOT NULL DEFAULT '0',
`friend` tinyint(1) NOT NULL DEFAULT '0',
`password` varchar(10) NOT NULL DEFAULT '',
`target_ids` text NOT NULL,
PRIMARY KEY (`albumid`),
KEY `uid` (`uid`,`updatetime`),
KEY `friend` (`friend`,`updatetime`),
KEY `updatetime` (`updatetime`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
SQL 查询:
-- -------------------------------------------------------- -- -- ?�?ṹ `uchome_udisk` -- CREATE TABLE `uchome_udisk` ( `albumid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `albumname` varchar(50) NOT NULL DEFAULT '', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `username` varchar(15) NOT NULL DEFAULT '', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', `picnum` smallint(6) unsigned NOT NULL DEFAULT '0', `pic` varchar(60) NOT NULL DEFAULT '', `picflag` tinyint(1) NOT NULL DEFAULT '0', `friend` tinyint(1) NOT NULL DEFAULT '0', `password` varchar(10) NOT NULL DEFAULT '', `target_ids` text NOT NULL, PRIMARY KEY (`albumid`), KEY `uid` (`uid`,`updatetime`), KEY `friend` (`friend`,`updatetime`), KEY `updatetime` (`updatetime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
MySQL 返回:
#1050 - Table 'uchome_udisk' already exists |