Linux服务器: php : PHP Version 5.2.5
mysql: Version 5.1.35运行如下的两个sql语句没有问题:
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ,pmd_listcat;
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ON pmd_users.userid=pmd_listings.userid ;但是运行:
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ,pmd_listcat ON pmd_users.userid=pmd_listings.userid 就报如下错误,不知为啥?是没配置好吗?望大大们不吝赐教,谢谢!#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 'ON pmd_users.userid=pmd_listings.userid LIMIT 0, 30' at line 1
mysql: Version 5.1.35运行如下的两个sql语句没有问题:
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ,pmd_listcat;
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ON pmd_users.userid=pmd_listings.userid ;但是运行:
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ,pmd_listcat ON pmd_users.userid=pmd_listings.userid 就报如下错误,不知为啥?是没配置好吗?望大大们不吝赐教,谢谢!#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 'ON pmd_users.userid=pmd_listings.userid LIMIT 0, 30' at line 1
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ON pmd_users.userid=pmd_listings.userid
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ON pmd_users.userid=pmd_listings.userid ,pmd_listcat
SELECT pmd_listings.* FROM pmd_listings INNER JOIN (pmd_users ,pmd_listcat) ON pmd_users.userid=pmd_listings.userid
SELECT pmd_listings.* FROM pmd_listings INNER JOIN (pmd_users ,pmd_listcat) ON pmd_users.userid=pmd_listings.userid先试下完整的语句,有没有其它的问题有问题再请教,谢谢大大了ps:
1. pmd_listcat 还有其他的查询条件,我没贴出来
2。不知道版本哪边有差异了
mysql我是用源码安装的, 是不是什么选项有问题?
./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql
make
make install
........
改成:
SELECT pmd_listings.* FROM pmd_listings INNER JOIN pmd_users ON pmd_users.userid=pmd_listings.userid ,pmd_listcat 这样不行吗?
那就奇怪了
期待进一步分析...
[email protected]