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