SQLite db_num_rows VS count
#5

Quote:
Originally Posted by Quis
Посмотреть сообщение
Thanks for your answers

COUNT uses field name as parameter, so if you COUNT(*) you counting by all fields - I think it's a bad habit
COUNT(NULL), or COUNT(0) return just empty rows
It doesn't matter which on you use, but i prefer the COUNT(*) one, since NULL looks weird in SELECT.
Reply


Messages In This Thread
SQLite db_num_rows VS count - by Quis - 23.11.2017, 20:43
Re: SQLite db_num_rows VS count - by BlackBank - 23.11.2017, 23:02
Re: SQLite db_num_rows VS count - by L97 - 23.11.2017, 23:11
Re: SQLite db_num_rows VS count - by Quis - 24.11.2017, 15:10
Re: SQLite db_num_rows VS count - by BlackBank - 24.11.2017, 17:55
Re: SQLite db_num_rows VS count - by L97 - 24.11.2017, 22:59

Forum Jump:


Users browsing this thread: 1 Guest(s)