Help with querying database stats in a given date range

bwhenry · 05-27-2015, 01:32 PM

I have similar thread in the general discussions forum, but thought I would throw something out here too.

For a solo league I am running I really want to be able to produce split stats that would be for the last 10 days. In-game offers only last week or monthly stats in the split options.

I know statslab and OOTPU offer this functionality for online leagues, but wonder if there is any way to use it for solo leagues? Or, how difficult it would be to put together a query for this if I just dumped my database locally and used MySQL?

To be honest, I have little to no experience with running queries, so I'm wondering how simple it would be for someone to put together? And, if it is relatively simple, if someone would be willing to me out.

It would be even cooler if it could be used for any date range, but that is not a necessity as I imagine it would make it more complex.

Thanks in advance for any feedback/help.

SeaBear · 07-19-2015, 03:37 PM

So have you exported data out to a CSV yet?

05-27-2015, 01:32 PM	#1
bwhenry Minors (Double A) Join Date: Jul 2010 Location: Minnesota Posts: 146	Help with querying database stats in a given date range I have similar thread in the general discussions forum, but thought I would throw something out here too. For a solo league I am running I really want to be able to produce split stats that would be for the last 10 days. In-game offers only last week or monthly stats in the split options. I know statslab and OOTPU offer this functionality for online leagues, but wonder if there is any way to use it for solo leagues? Or, how difficult it would be to put together a query for this if I just dumped my database locally and used MySQL? To be honest, I have little to no experience with running queries, so I'm wondering how simple it would be for someone to put together? And, if it is relatively simple, if someone would be willing to me out. It would be even cooler if it could be used for any date range, but that is not a necessity as I imagine it would make it more complex. Thanks in advance for any feedback/help. __________________ My avatar is of Peter Cobb, 1st baseman for the Minneapolis Cobras, and reigning Hitter of the Inning in the The Minnesota Baseball League - A daily dynasty report on a 10 team all Minnesota league

07-19-2015, 03:37 PM	#2
SeaBear Minors (Double A) Join Date: Jul 2012 Posts: 116	So have you exported data out to a CSV yet?