mysql获取分页数据的语句怎么写

Question

因为在做php列表分页，打个比方，开始id 0 取10条

Answer 1

$p = 1; //当前页 $pageSize = 10; //每页条数 $a = ($p-1)*$pageSize; $b = $p*$pageSize; $sql = "select * from name where id >= '".$a."' and id < '".$b."'";

Answer 2

where id < 10