select * from `table` where id>=5这是获取 id大于等于5的select * from `table` where id>=5 and id=5 limit 0,10大于5 的获取10条数据select * from `table` where id>=5 order by id
id排序后获取...
按id取值 select * from table where id between 5 and 10select * from table limit m,n其中m是指记录开始的index，从0开始，表示第一条记录n是指从第m+1条开始，取n条。select * from tablename limit 2,4即取出第3条至第6...
