mysql count
#2

Код:
SELECT COUNT(*) as count FROM objects WHERE Owner = '%s'
and then just get count field, or get field at index 0,
but I don't suggest using sql COUNT as it is expensive, it may take less time if you count it in pawn
Reply


Messages In This Thread
mysql count - by jeffery30162 - 18.01.2015, 23:42
Re: mysql count - by CoaPsyFactor - 18.01.2015, 23:47
Re: mysql count - by jeffery30162 - 19.01.2015, 00:04
Re: mysql count - by jeffery30162 - 19.01.2015, 00:49
Re: mysql count - by PaulDinam - 19.01.2015, 01:57
Re: mysql count - by CoaPsyFactor - 19.01.2015, 02:10
Re: mysql count - by CoaPsyFactor - 19.01.2015, 02:12
Re: mysql count - by PowerPC603 - 19.01.2015, 06:42
Re: mysql count - by jeffery30162 - 19.01.2015, 19:16
Re: mysql count - by jeffery30162 - 19.01.2015, 19:23

Forum Jump:


Users browsing this thread: 2 Guest(s)