php - mysql选择查询

Question

    3717    8   2012-03-30 16:34:17
    3718    10  2012-03-30 16:34:22
    3719    9   2012-03-30 16:34:27
    3720    6   2012-03-30 16:34:32
    3721    7   2012-03-30 16:34:37
        3722    8   2012-03-30 16:34:42
    3723    10  2012-03-30 16:34:47
    3724    5   2012-03-30 16:34:50

我有这个 mysql 表，我想选择最后 10 条记录，这是我的代码

SELECT * FROM mach_1 ORDER BY id DESC  LIMIT 10

这是我得到的

2012-03-30 16:34:50
2012-03-30 16:34:47
2012-03-30 16:34:42
2012-03-30 16:34:37
2012-03-30 16:34:32
2012-03-30 16:34:27
2012-03-30 16:34:22
2012-03-30 16:34:17
2012-03-30 16:34:10
2012-03-30 16:34:05

问题是我怎样才能扭转这一局面

Answer 1

尝试这样的事情:

select * from (select * from mach_1 order by id desc 
limit 10) as tbl order by tbl.id;