View Single Post
Old 04-18-2018, 02:18 AM   #17
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,163
Quote:
Originally Posted by NoOne View Post
you can do that in sql too. make a query or report etc.. save for re-use. you wouldn't have to export and use excel.

sql is easy stuff.. at least at this level of use.. syntax may be slightly differnet, but same same logic as what you are using in excel.

edit: lol it is in the dB, nevermind.. leaving the above to look stupid anyway...

what's wrong with mysql intallation? check mysql.ini?

a good all-in-one that comes wokrign out of the box is mariadB and i use a free heidi-sql for a front end. setup differnet users for access to different dB, or at least i like to.. keeps 'tree' view clean.


Yeah, all of the depth chart stuff is in excel using csv output generated by the dB.

The find-a-batter and pitcher are stored procedures accessed directly from the dB.

If you know anything about MySQL server on Mac, I’d love to trouble-shoot it with someone. By default, Mac doesn’t create a my.cnf for MySQL and I need to create one to be able to write to a file from the server. To complicate matters, the server is running, but can’t be restarted or stopped. Something about a missing pid file. Seriously, if you know anything about this, I’d like to pick your brain.


Sent from my iPhone using Tapatalk
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery
cavebutter is offline   Reply With Quote