I'm looking for an MySQL-compatible SQL query that will, given a year range and a stat, provide me with either (ideally) a major league average per year for...
Derek, I'm having a heckuva time following the request here (though, the A/C is out here, and I can barely focus). If you send me an email with your contact...
... Hash: SHA1 ... OK, first we need some raw data: PID Year Part Games Hits ABs 150 1994 1 25 7 44 150 1995 1 82 40 200 150 1996 1 101 60 286 150 1997 1 81 37...
Why not just create a view containing a players yearly counting stats and run another query against that. For example: create or replace view batting_yearly...
... Hash: SHA1 ... Views are not yet implemented in MySQL. Transactions, foreign keys, and views were features that MySQL had traditionally stayed away from...
Re: MySQL SQL syntax help On Mon Jun 14, 2004, Derek Adair asked for ... The following worked on my planet. I believe that on planet MySQL, the IIF() function...
As a few people here use Access to import through csv or Excel, you may want to be aware of a (very annoying) problem with Access 2003. (We can talk at length...
I'm trying to get a file that contains for 2004 position players: playerid,playername,team,games Playerid is not required, but would be preferable. Anyone who...
... Just to make sure, something like this: http://www.sportsline.com/mlb/stats/playersort/regularseason/yearly/MLB/ALL?&print_rows=9999 is not good enough, as...
Just got the following note about postseason fielding records with invalid IDs. I've checked, and these should be changed to: macdobo01(Bob MacDonald),...
Sean: Since I'll be working on this file in a few days to change some of the "OF" positions of the 2003 postseason data to "CF, LF, RF" data (and since these...
I was actually much closer to completing the "OF" replacments than I thought, so the file will be uploaded in just a few minutes with these corrections: 1....
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Jul 9, 2004 3:43 am
2187
Hi. I would like to begin work on a UI for Lahman 5.1 in Access and I was wondering if anyone knew of already existing UI's. Thanks in advance. David Dvorin ...
I would like a query with all the batting stats from 1990 on, by stint, BUT with columns for games played at each position. I'd also like to exclude pitchers....
I find the easiest thing is to create a matrix table. Create a table called PosMatrix, that looks like: Pos,Pos1,Pos2,Pos3...Pos9 1,1,0,0,0..,0 2,0,1,0,...,0 ...
On Sat Jul 10, 2004, Rob Miller asked for ... This worked on Planet Access: SELECT b.*, (SELECT f.G FROM fielding as f WHERE b.playerID = f.playerID AND ...
I looked in Files but did not spot anything. I want to determine Slugging allowed by pitchers but do not have doubles and triples allowed by pitchers. Does...
Jonathan Frankel is compiling those two and four other elementary statistics for 1899. He has consulted some sources, maybe enough to cover the field. I...
Ok, getting the W-L record for a team in 1-run games from the game log files. I've created a big table of game data, 1 row for each game. I know how to get the...
... Hi, There is a thread above discussing what new data to add to the database and 2B and 3B allowed are on the list, I believe. Right now, they are not...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
