id int( 11 ) NOT NULL AUTO_INCREMENT , domain varchar( 255 ) NOT NULL , reffer varchar( 255 ) NOT NULL , pr tinyint( 4 ) NOT NULL , searchdate datetime NOT NULL , PRIMARY KEY ( id ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1147897;
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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1147897' at line 8
14 条评论
我有linex 空间
怎么没看到在哪下
怎么让所有网站都可以引用?也就是去除授权功能?
恩
呵呵
HOHO~~~~不错哦!
慢慢研究一下吧,数据库没对,你自己根据你的情况改一下就可以了.
唉,老猫至少也要写出来配置嘛...我mysql还是4呢..
Table 'qiuai_blog.PageRank_stat' doesn't exist SELECT SUM(searchCount) FROM PageRank_stat
数据库出错:
MySQL Query Error
Mysql error description: Table 'qiuai_blog.PageRank_stat' doesn't exist
Mysql error number: 1146
Date: 2008-10-11 @ 12:08
Script: http://www.9iuai.cn/pr/
现在又开始出这个....
CREATE TABLE IF NOT EXISTS
PageRank
(id
int( 11 ) NOT NULL AUTO_INCREMENT ,domain
varchar( 255 ) NOT NULL ,reffer
varchar( 255 ) NOT NULL ,pr
tinyint( 4 ) NOT NULL ,searchdate
datetime NOT NULL ,PRIMARY KEY (
id
)) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1147897;
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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1147897' at line 8[quote=斧头帮]哎呀,我租的是WIN的主机。[/quote]网上有Windows主机下的PR查询类,直接调用函数就可以了.
哎呀,我租的是WIN的主机。