错误
SQL 查询:
CREATE TABLE IF NOT EXISTS `uchome_musicbox` (
`songid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`albumid` mediumint( 8 ) unsigned NOT NULL default '0',
`userid` mediumint( 8 ) unsigned NOT NULL ,
`usersay` text CHARACTER SET gb2312,
`songname` varchar( 255 ) CHARACTER SET gb2312 NOT NULL ,
`label` varchar( 255 ) CHARACTER SET gb2312 default NULL ,
`singer` varchar( 255 ) CHARACTER SET gb2312 default NULL ,
`Categories` varchar( 255 ) CHARACTER SET gb2312 default NULL ,
`lang` int( 4 ) unsigned NOT NULL ,
`songurl` varchar( 255 ) CHARACTER SET gb2312 NOT NULL ,
`lyric` text CHARACTER SET gb2312,
`commenduser` varchar( 255 ) CHARACTER SET gb2312 default NULL ,
`collectionuser` varchar( 255 ) CHARACTER SET gb2312 default NULL ,
`commendtotal` int( 8 ) unsigned NOT NULL default '0',
`playtotal` int( 8 ) unsigned NOT NULL default '0',
`upload` int( 4 ) unsigned NOT NULL default '1',
`down` int( 4 ) unsigned default '0',
`comment` varchar( 255 ) CHARACTER SET gb2312 default NULL ,
`dataline` int( 10 ) unsigned NOT NULL ,
PRIMARY KEY ( `songid` )
) DROP TABLE IF EXISTS `uchome_musicbox_album`
MySQL 返回:
#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 'DROP TABLE IF EXISTS `uchome_musicbox_album`' at line 23 |