摘要： limit是mysql的语法select * from table limit m,n其中m是指记录开始的index，从0开始，表示第一条记录n是指从第m+1条开始，取n条。select * from tablename limit 2,4即取出第3条至第6条，4条记录CI 用法$query = $this->db->get('mytable', 10, 20);SELECT * FROM mytable LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax) 阅读全文