MySQL子查询LIMIT

• Z时代
• 2024-01-10
• 分类：问答

如标题所述，我想要一个解决方法…

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))

干杯

回答：

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

您可能会希望将an添加ORDER BY到嵌套查询中。

以上是 MySQL子查询LIMIT 的全部内容， 来源链接： utcz.com/qa/401269.html