我想用php从数据库中获取数据[重复]

Question

This question already has an answer here:

• MySQL: how to select everything except first 10 records 2 answers

I want to fetch all the records from database but after top 10 rows, i don't want to fetch top 10 rows.

</div>

Answer 1

You need to use OFFSET, example:

SELECT * FROM `table` ORDER  BY `id` OFFSET 10;