Basing a boolean function on MySQL data

Linear Mode

Vince
Spam Machine

Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0

31.10.2014, 11:10

Quote:

Originally Posted by Kikito

By the way, change the "COUNT(*)" for "COUNT(<primary key>)"

I hope this helps you out!

That has no effect at all. COUNT(*) simply counts all the rows in the table, while COUNT(key) counts all the rows in the table for which key is not null. And given that the primary key is never null they will just return the same thing.

Find

« Next Oldest | Next Newest »

Messages In This Thread

Basing a boolean function on MySQL data - by Partner - 30.10.2014, 22:07

Re: Basing a boolean function on MySQL data - by Djole1337 - 30.10.2014, 22:13

Re: Basing a boolean function on MySQL data - by GWMPT - 30.10.2014, 22:21

Re: Basing a boolean function on MySQL data - by Partner - 31.10.2014, 08:02

Re: Basing a boolean function on MySQL data - by Partner - 31.10.2014, 09:09

Re: Basing a boolean function on MySQL data - by GWMPT - 31.10.2014, 11:02

Re: Basing a boolean function on MySQL data - by Vince - 31.10.2014, 11:10

Re: Basing a boolean function on MySQL data - by Partner - 31.10.2014, 11:17

Re: Basing a boolean function on MySQL data - by GWMPT - 31.10.2014, 11:19

View a Printable Version

Forum Jump:

Users browsing this thread: 2 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me