Mysql限制功能似乎对我不起作用

Question

这是我的查询，

select t1.dSyllabus_id,t1.dBatch,t1.dFilePathName,
t2.dDegreeName,t3.dDepartmentAbbr
from tbl_syllabus as t1
join tbl_degree_master as t2,
tbl_department_master as t3
where t2.dDegree_id=t1.dDegree_id 
and t3.dDepartment_id=t1.dDepartment_id
and t1.dCollege_id='1'
and t1.dIsDelete='0'

我得到

无限制 http://img534.imageshack.us/ img534/2165/withoutlimi.jpg

应用限制，

 select t1.dSyllabus_id,t1.dBatch,t1.dFilePathName,
    t2.dDegreeName,t3.dDepartmentAbbr
    from tbl_syllabus as t1
    join tbl_degree_master as t2,
    tbl_department_master as t3
    where t2.dDegree_id=t1.dDegree_id 
    and t3.dDepartment_id=t1.dDepartment_id
    and t1.dCollege_id='1'
    and t1.dIsDelete='0'
    limit 0,5

我得到，

有限制 http ://img13.imageshack.us/img13/2470/withlimit.jpg

我没有得到前五个记录，为什么？

Answer 1

您获得了 5 条记录，但您尚未下订单。除非您也告诉他们，否则他们不会按特定顺序返回。就你而言，我相信你希望它们按照 ID 的顺序排列。添加类似的内容：

order by `t1`.`dSyllabus_id` ASC

因此您的查询如下所示：

select t1.dSyllabus_id,t1.dBatch,t1.dFilePathName,
t2.dDegreeName,t3.dDepartmentAbbr
from tbl_syllabus as t1
join tbl_degree_master as t2,
tbl_department_master as t3
where t2.dDegree_id=t1.dDegree_id 
and t3.dDepartment_id=t1.dDepartment_id
and t1.dCollege_id='1'
and t1.dIsDelete='0'
order by `t1`.`dSyllabus_id` ASC
limit 0,5

Answer 2

使用排序依据

and t1.dIsDelete='0'
    ORDER BY 't1.dSyllabus_id'
    limit 0,5