MYSQL从表中选择，获取表中的最新/最后10行 [英] MYSQL Select from table, get newest/last 10 rows in table

问题描述

什么是最好，最简单的方法?我的查询当前是:

What's the best, and easiest way to do this? My query currently is:

  SELECT * 
    FROM chat 
   WHERE (userID = $session AND toID = $friendID) 
      OR (userID = $friendID AND toID = $session) 
ORDER BY id 
   LIMIT 10

尽管如此，它显示的是前10行，而不是最后10行.

This shows the first 10 rows though, not the last 10.

我想要最后10行(这是，DESC这样做)，但是我希望它们以升序返回.

I Want the last 10 rows (Which yes, DESC does this) However I want them to be returned in ASCENDING order.

推荐答案

要颠倒顺序(因此获取最后10个而不是前10个)，请使用DESC代替ASC

to reverse the order (therefore get last 10 instead of first 10), use DESC instead of ASC

编辑

根据您的评论:

SELECT * FROM (
  SELECT * 
  FROM chat 
  WHERE (userID = $session AND toID = $friendID) 
    OR (userID = $friendID AND toID = $session)  
  ORDER BY id DESC
  LIMIT 10
) AS `table` ORDER by id ASC

这篇关于MYSQL从表中选择，获取表中的最新/最后10行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！