MySQL的子查询LIMIT

Question

正如标题所说，我想为这一个解决办法...

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

干杯

Answer 1

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 

你可能会想一个ORDER BY添加到嵌套查询。