如何在ASC中显示从该查询收到的记录?
SELECT accounts.Nickname, chat.AccountID, chat.Message, chat.DateTime, accounts.Color
FROM (chat INNER JOIN accounts ON chat.AccountID = accounts.AccountID)
ORDER BY chat.MessageID DESC
LIMIT 100
将原始查询放入派生表(子查询(中,并按ASC顺序排列结果。
SELECT * FROM
(
SELECT accounts.Nickname, chat.AccountID, chat.Message, chat.DateTime, accounts.Color, chat.MessageID
FROM (chat INNER JOIN accounts ON chat.AccountID = accounts.AccountID)
ORDER BY chat.MessageID DESC
LIMIT 100
) dt
ORDER BY MessageID ASC