There is really a difference when using the lLIMIT condition in this format lLIMIT 1,2; and this LIMIT 1 OFFSET 2; ?? Plz help !

Answer 1

Limit 1,2
Offset = 1
count = 2

Limit 1 offset 2
offset=2
Count=1

Answer 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

Answer 3

Thank you guys

Answer 4

isnt that same? limit 1,2 is shortcut for limit 1 offeset 2..or am i wrong too?

Answer 5

I thought the same but while trying it on an exercise it returned different results

Answer 6

oh..reallyy..i didnt notice that