Did you mean fourth position? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Did you mean fourth position?

If the index is 3, doesn't that mean from the fourth position? in the example you say starting from the 3rd item.

23rd Jul 2018, 7:21 PM
Alain-Daniel W.
Alain-Daniel W. - avatar
5 Answers
+ 3
I imagine you refer to this example (get 4 records, starting from the third position): SELECT ID, FirstName, LastName, City   FROM customers LIMIT 3, 4; LIMIT counts the records differently, that is, starts counting the records from 1. If you execute an instruction like SELECT * FROM table LIMIT 0; you will not get any record, since you are indicating that you do not want any of them. If you execute SELECT * FROM table LIMIT 3; You will get 3 records, and so on.
23rd Jul 2018, 7:37 PM
Mickel
Mickel - avatar
+ 1
KrOW , sorry, I was addressing the author of the lesson, but Mickel did help.
26th Jul 2018, 6:42 PM
Alain-Daniel W.
Alain-Daniel W. - avatar
+ 1
Alain The important is that you learned something 😉. Anyway next times, please, make more clear your question 😅
26th Jul 2018, 7:11 PM
KrOW
KrOW - avatar
0
With who you are talking?
23rd Jul 2018, 7:35 PM
KrOW
KrOW - avatar
0
Thank you, Mickel .
26th Jul 2018, 6:41 PM
Alain-Daniel W.
Alain-Daniel W. - avatar