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
解决方案 »
- 【急】有没有支持Mysql 5.1.45版本的Fulltext啊?
- 请教一下,Mysqlr Event(事件)设定。
- 求MYSQL多表联合查询方案
- ?postgresql sql语句看不懂
- 3台机器mysql数据同步失败
- 各位大侠,帮忙看一句sql,搞了半天了就是不对啊
- 怎样让使用代理服务器来访问MYSQL网络数据库
- 这样为什么不行.select * from table1 where table1.aa in (select aa from table2)
- 在KDevelop下编写mysql程序的问题?急急急急急急!!!!
- 2张表的结构不一样字段也不一样,我要同步2个表的数据怎么做,通过定时器来实现。
- MySQL中建立一个只能用户看到的视图
- 復雜sql查詢求助
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]