CREATE TABLE `pre_music_recommend` (
`rid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT COMMENT '推荐ID ',
`songid` mediumint( 8 ) unsigned NOT NULL COMMENT '音乐ID',
`uid` mediumint( 8 ) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`depict` text NOT NULL COMMENT '歌曲描述 ',
`dateline` int( 10 ) unsigned NOT NULL DEFAULT '0' COMMENT '推荐时间戳',
PRIMARY KEY ( `rid` ) ,
KEY `dateline` ( `uid` , `dateline` ) USING BTREE) ENGINE = MYISAM AUTO_INCREMENT =1 DEFAULT CHARSET = gbk COMMENT = '音乐推荐表';
语句 ,数据库是dz x2的gbk 数据库,在数据库里面执行sql语句 (上面)
出现问题
#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 'USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk COMMENT='音ä¹' at line 8
还请高手指教
`rid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT COMMENT '推荐ID ',
`songid` mediumint( 8 ) unsigned NOT NULL COMMENT '音乐ID',
`uid` mediumint( 8 ) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`depict` text NOT NULL COMMENT '歌曲描述 ',
`dateline` int( 10 ) unsigned NOT NULL DEFAULT '0' COMMENT '推荐时间戳',
PRIMARY KEY ( `rid` ) ,
KEY `dateline` ( `uid` , `dateline` ) USING BTREE) ENGINE = MYISAM AUTO_INCREMENT =1 DEFAULT CHARSET = gbk COMMENT = '音乐推荐表';
语句 ,数据库是dz x2的gbk 数据库,在数据库里面执行sql语句 (上面)
出现问题
#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 'USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk COMMENT='音ä¹' at line 8
还请高手指教
应该是 COMMENT = '音乐推荐表' 这里没有通过(奇怪,为什么别的COMMENT不报错呢)
这是字符集不对而产生的
先执行 set names gbk 看看