# select * from employees limit 5 OFFSET 5 # 方法一:结合offset:offset表示偏移,从第几条记录开始 # select * from employees limit 5 OFFSET 5 # 方法二:只用limit limit(x,y) 从第x条记录(不包含x)后开始,返回y条数据 # select * from employees limit 5, 5 select * from employees limit 5,5
# select * from employees limit 5 OFFSET 5 # 方法一:结合offset:offset表示偏移,从第几条记录开始 # select * from employees limit 5 OFFSET 5 # 方法二:只用limit limit(x,y) 从第x条记录(不包含x)后开始,返回y条数据 # select * from employees limit 5, 5 select * from employees limit 5,5