SQLite help.
#6

Quote:
Originally Posted by LoLeRo
Посмотреть сообщение
Ok, but i need in this case to put "LIMIT 1" necessarily? Because as you said, i'm only expecting 1 row because there is only 1 username with that nick at all the table. I'm asking this because i have other querys in which i don't use LIMIT 1.
Thanks.
Well putting a limit can be called more efficient and faster than not because it basically limits the amount of data to be loaded. In case you are only using one row, use LIMIT 1.

Or all in all, use LIMIT where ever you know how much maximum it can go or how much maximum amount of rows you want.
Reply


Messages In This Thread
SQLite help. - by LoLeRo - 26.07.2016, 02:58
Re: SQLite help. - by Gammix - 26.07.2016, 03:07
Respuesta: Re: SQLite help. - by LoLeRo - 26.07.2016, 03:22
Re: Respuesta: Re: SQLite help. - by Gammix - 26.07.2016, 03:26
Respuesta: SQLite help. - by LoLeRo - 26.07.2016, 03:43
Re: Respuesta: SQLite help. - by Gammix - 26.07.2016, 03:46
Respuesta: SQLite help. - by LoLeRo - 26.07.2016, 03:48

Forum Jump:


Users browsing this thread: 2 Guest(s)