select * from a limit 0,100select * from a limit 100,100select * from a limit 200,100
2 回答
慕標(biāo)琳琳
TA貢獻(xiàn)1830條經(jīng)驗(yàn) 獲得超9個贊
limit是mysql中限制結(jié)果集行數(shù)的。
這樣的寫法會不會重復(fù)也不一定，因?yàn)槟銢]有對結(jié)果集排序，所以記錄順序可能不是一定的。
排序后順序就確定了，比如：
select * from a order by 某列 limit 0,100
30秒到達(dá)戰(zhàn)場
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超6個贊
mysql> select * from a limit 0,2;
+------+-------+--------+--------+
| id | name | result | remark |
+------+-------+--------+--------+
| 1 | wall1 | CN | O |
| 2 | wall1 | CN2 | 2 |
+------+-------+--------+--------+
2 rows in set (0.00 sec)
mysql> select * from a limit 2,2;
+------+-------+--------+--------+
| id | name | result | remark |
+------+-------+--------+--------+
| 3 | wall1 | CN | O |
| 4 | wall1 | CN | O |
+------+-------+--------+--------+
2 rows in set (0.00 sec)
mysql> select * from a limit 4,2;
+------+-------+--------+--------+
| id | name | result | remark |
+------+-------+--------+--------+
| 5 | wall1 | CN | O |
| 6 | wall1 | CN | O |
+------+-------+--------+--------+
2 rows in set (0.00 sec)
添加回答
舉報
0/150
提交
取消