MySQL 子查询限制
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2856397/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-31 16:04:37 来源:igfitidea点击:
MySQL Subquery LIMIT
提问by Atif Mohammed Ameenuddin
As the title says, I wanted a workaround for this...
正如标题所说，我想要一个解决方法......
SELECT
comments.comment_id,
comments.content_id,
comments.user_id,
comments.`comment`,
comments.comment_time,
NULL
FROM
comments
WHERE
(comments.content_id IN (SELECT content.content_id FROM content WHERE content.user_id = 1 LIMIT 0, 10))
Cheers
干杯
回答by Quassnoi
SELECT comments.comment_id,
comments.content_id,
comments.user_id,
comments.`comment`,
comments.comment_time,
NULL
FROM (
SELECT content.content_id
FROM content
WHERE content.user_id = 1
LIMIT 10
) q
JOIN comments
ON comments.content_id = q.content_id
You probably will want to add an ORDER BYinto the nested query.
您可能希望ORDER BY在嵌套查询中添加。
