思路很简单,先count出表的数据量,再根据limit构造的方式查询;
应用场景:
1、单字段的数据表;
2、无索引数据表;
例:查询最后四条数据
$_a = query("select count(*) from table_x");
$_b = 4;
$_data = query("select * from table_x limit $_a-$_b, $_b");
$_a = query("select count(*) from table_x");
$_b = 4;
$_data = query("select * from table_x limit $_a-$_b,$_b");