1.查询前五条数据
select * from tableName limit 0,5;
或者
selecr * from tableName limit 5;
2.查询第五页的前五条数据(假设每页10行)
select * from tableName limit (5-1)*10,5;
1.查询前五条数据
select * from tableName limit 0,5;
或者
selecr * from tableName limit 5;
2.查询第五页的前五条数据(假设每页10行)
select * from tableName limit (5-1)*10,5;