+ 1
There is really a difference when using the lLIMIT condition in this format lLIMIT 1,2; and this LIMIT 1 OFFSET 2; ?? Plz help !
6 Réponses
+ 2
Limit 1,2
Offset = 1
count = 2
Limit 1 offset 2
offset=2
Count=1
+ 2
I am not aware of ILIMIT (as written in the thread title). But if you meant LIMIT, then the value position (value for limit & offset) is reversed when using comma as argument separator.
[Normal]
SELECT <column-list> FROM <table> LIMIT <result-limit> OFFSET <record-index>
[Short form]
SELECT <column-list> FROM <table> LIMIT <record-index>, <result-limit>
* Noted from:
https://www.w3schools.com/php/php_mysql_select_limit.asp
+ 2
Thank you guys
+ 1
isnt that same? limit 1,2 is shortcut for limit 1 offeset 2..or am i wrong too?
+ 1
I thought the same but while trying it on an exercise it returned different results
0
oh..reallyy..i didnt notice that