急求求大家帮忙-数据库个人信息出错代码如下!
Discuz! info: MySQL Query Error
[email protected]
User: dengrenfu
Time: 2008-4-29 1:34pm
Script: /bbs/space.phpSQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
Error: 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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064Similar error report has beed dispatched to administrator before.
Discuz! info: MySQL Query Error
[email protected]
User: dengrenfu
Time: 2008-4-29 1:34pm
Script: /bbs/space.phpSQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
Error: 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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064Similar error report has beed dispatched to administrator before.
解决方案 »
- mysql建立外键发生错误,求救
- 两个数据库如何相连?(请高人指点)
- mysql delete 数据还原
- MySQL语句中模糊匹配参数的问题
- mysql重装出现1067错误,can't connect mysql on localhost(10061),以前的贴都不能解决
- 字符串累加问题????
- [求助]MySql下如果没有赋值为什么是""而不是Null呢?高手们帮帮忙啊
- 哪为高人做过DBMS啊?帮忙给指点一下,这学期我们课程设计要实现一个DBMS
- limit不支持内层嵌套。。。。。。。。。。。。。。
- 这条语句为什么报错?
- 请高手推荐本MySQL的好书
- Amoeba for mysql 0.12发布(轻易解决读写分离、数据切分)
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM members m
LEFT JOIN memberfields mf ON mf.uid=m.uid
LEFT JOIN usergroups u ON u.groupid=m.groupid
LEFT JOIN ranks r ON m.posts>=r.postshigher
LEFT JOIN pig p ON p.userb=m.username
LEFT JOIN onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1 似乎问过吧
Discuz! info: MySQL Query Error
[email protected]
User: dengrenfu
Time: 2008-4-29 1:34pm
Script: /bbs/space.phpSQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
Error: 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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064Similar error report has beed dispatched to administrator before.
如果有谁知道?
加我QQ:289625925与我联系!谢谢大家!
SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM members m
LEFT JOIN memberfields mf ON mf.uid=m.uid
LEFT JOIN usergroups u ON u.groupid=m.groupid
LEFT JOIN ranks r ON m.posts>=r.postshigher
LEFT JOIN pig p ON p.userb=m.username
LEFT JOIN onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1 出错信息?
在MYSQL中运行有无问题?
WHERE m.uid='49616'ORDER BY r.po' at line 9
你的这个g有没有去掉啊[align=center]==== 思想重于技巧 ====
[/align]
[/align]
[/align]
mysql> select * from members where uid='49616';
Empty set (0.86 sec)[align=center]==== 思想重于技巧 ====
[/align]
怎么没有UID呢?
[/align]
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM ((((members as m LEFT JOIN memberfields mf ON mf.uid=m.uid)
LEFT JOIN usergroups as u ON u.groupid=m.groupid )
LEFT JOIN ranks as r ON m.posts>=r.postshigher )
LEFT JOIN pig as p ON p.userb=m.username )
LEFT JOIN onlinetime as o ON o.uid=m.uid
WHERE m.uid='49616'[align=center]==== 思想重于技巧 ====
[/align]
[/align]
Discuz! info: MySQL Query Error
[email protected]
User: dengrenfu
Time: 2008-4-29 1:34pm
Script: /bbs/space.php SQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
Error: 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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064 Similar error report has beed dispatched to administrator before.
如果有谁知道?
加我QQ:289625925与我联系!谢谢大家!