stats4gnats

dalecosp, Maybe I’m just jumpin’ in way over my head here, so let me go back a bit and try again. In the class, they had something called the SQL sandbox. It was using MYSQL to access a couple different databases in order to grab baseball data. I have no idea if it was accessing the data, locally or through the web. All I know is, I typed a seql statement, ran it, and could download the results as a .csv I could put on my machine. Then I could run R to massage it, mainly to do plots, histograms, regressions, etc.. In FoxPro, you create .DBF files or databases, then use SQL statements mixed in with their version of Visual Basic language to put data in, massage it, and generate reports. All I want to do, at least for now, is to be able to download the databases to my machine, then point MYSQL to it somehow so when I run a select, it goes to the right place, and generates a .CSV. Unfortunately, I don’t see anything in the workbench that gives me access to some kind of console where selects can be typed. Thanx to you, I at least have someplace to look, with the community server. I’ll spend a bit of time checking it out and getting it on my box. Maybe then I’ll be able to speak a bit more intelligently in order to ask better questions. Thank you very much. I really appreciate your time. S4G

I'm 67 and long been a baseball lover, and in enjoying the game, I've been the guy who keeps score, gathers data, mines it a bit, and produces lots of metrics for people to look at. Out of curiousity, I took a Sabermetrics class that was recently offered on-line and was introduced to SQL and R. I've been using Visual FoxPro since before it was visual, and in it there's a SQL set they use which I'm fairly familiar with. In the class, we used MYSQL and databases readily availabe from various baseball sources, so what I'm tryinng to do is download those databases to my box, install MYSQL, and install R so I can continue to play around and learn. I've got the R Studio they had us in the class, and the databases shouldn't be a problem, but MYSQL is giving me fits. I installed this thing called MYSQL Workbench, but its pretty confusing and I can't find basic tutorials on it. So that's where I'm at. My system is Windows 7. This isn't an avocation for me! Its my hobby and gives me many hours of enjoyment, and I'm looking for some basic help to expand what I can do. Any help will be greatly appreciated. S4G