+ 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 !

30th Mar 2020, 3:22 PM
kamel BOUHENNI
kamel BOUHENNI - avatar
6 Réponses
+ 2
Limit 1,2 Offset = 1 count = 2 Limit 1 offset 2 offset=2 Count=1
30th Mar 2020, 3:46 PM
Ore
Ore - avatar
+ 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
30th Mar 2020, 3:56 PM
Ipang
+ 2
Thank you guys
30th Mar 2020, 6:16 PM
kamel BOUHENNI
kamel BOUHENNI - avatar
+ 1
isnt that same? limit 1,2 is shortcut for limit 1 offeset 2..or am i wrong too?
30th Mar 2020, 3:26 PM
durian
durian - avatar
+ 1
I thought the same but while trying it on an exercise it returned different results
30th Mar 2020, 3:29 PM
kamel BOUHENNI
kamel BOUHENNI - avatar
0
oh..reallyy..i didnt notice that
30th Mar 2020, 3:37 PM
durian
durian - avatar