SQL语句是这样的:select
this_.id as id11_7_,
this_.qu as qu11_7_,
this_.name as name11_7_,
this_.shenqingbianhao as shenqing5_11_7_,
this_.address as address11_7_
from
persion this_ where
this_.qu=3
order by
this_.id desc limit 3结果查询出来以后,数据并没有按id进行desc排序,查询出来的ID是:1
2
3但是如果只查id:
SQL语句是这样的:select
this_.id as id11_7_
from
persion this_ where
this_.qu=3
order by
this_.id desc limit 3
这个时候就对了,查询出来是:
3
2
1这是为什么啊???
this_.id as id11_7_,
this_.qu as qu11_7_,
this_.name as name11_7_,
this_.shenqingbianhao as shenqing5_11_7_,
this_.address as address11_7_
from
persion this_ where
this_.qu=3
order by
this_.id desc limit 3结果查询出来以后,数据并没有按id进行desc排序,查询出来的ID是:1
2
3但是如果只查id:
SQL语句是这样的:select
this_.id as id11_7_
from
persion this_ where
this_.qu=3
order by
this_.id desc limit 3
这个时候就对了,查询出来是:
3
2
1这是为什么啊???
以供测试
6 3 6 6 1
5 3 5 5 1
4 3 4 4 1
MYSQL版本:5.1。17
6 3 6 6 1
5 3 5 5 1
4 3 4 4 1
MYSQL版本:5.1。17