使用 phpmyadmin 的 mySQL INNER JOIN 语法

发布于 2024-09-03 10:20:01 字数 416 浏览 2 评论 0原文

SELECT Question.userid, user.uid
FROM `question`
WHERE NOT `userid`=2
LIMIT 0, 60
INNER JOIN `user`
ON `question`.userid=`user`.uid
ORDER BY `question`.userid

返回错误：

您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，了解在 'INNER JOIN User ON question.userid=user.uid 附近使用的正确语法ORDER BY question.userid' at line 5

我一生都无法弄清楚我在这里做错了什么。

原文

SELECT Question.userid, user.uid
FROM `question`
WHERE NOT `userid`=2
LIMIT 0, 60
INNER JOIN `user`
ON `question`.userid=`user`.uid
ORDER BY `question`.userid

returns 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 'INNER JOIN User ON question.userid=user.uid ORDER BY question.userid' at line 5

Can't for the life of me figure out what I'm doing wrong here.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

最舍不得你 2024-09-10 10:20:01

您的查询看起来无效。您可能想尝试以下操作：

SELECT      `question`.userid, `user`.uid
FROM        `question`
INNER JOIN  `user` ON `question`.userid = `user`.uid
WHERE       `userid` <> 2
ORDER BY    `question`.userid
LIMIT       0, 60

Your query doesn't look valid. You may want to try the following:

SELECT      `question`.userid, `user`.uid
FROM        `question`
INNER JOIN  `user` ON `question`.userid = `user`.uid
WHERE       `userid` <> 2
ORDER BY    `question`.userid
LIMIT       0, 60

回复收藏 0 原文

~没有更多了~