View Full Version : Count hands in DB?
Gabethebabe
10-17-2008, 04:19 AM
Is there a way to count the number of hands I have stored in my database?
If it is, is it also possible to count the number of hands per stakes?
Thanks.
http://208.109.95.123/faq/afmviewfaq.aspx?faqid=19
Gabethebabe
10-17-2008, 02:03 PM
Kewl! Now how can I count just the NL100 hands, for example?
you have to play around with the SQL-query.
if you know sql: do the same query, group by gametype and left join with "gametypes".
if you downt know how sql works, tell me and i'll look at the query tomorrow.
Gabethebabe
10-18-2008, 01:42 AM
you have to play around with the SQL-query.
if you know sql: do the same query, group by gametype and left join with "gametypes".
if you downt know how sql works, tell me and i'll look at the query tomorrow.
I know some basic SQL, but at the moment we start with LEFT JOIN I´m afraid it´s out of my knowledge.
Im´interested in couting based on stakes and if possible on month, to know how much I´ve datamined in a month
ok, that does it:
SELECT gametypes.gametypedescription,count(*) FROM pokerhands LEFT JOIN gametypes ON pokerhands.gametype_id = gametypes.gametype_id GROUP BY gametypes.gametypedescription
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.