Jeff: Â Do you mean what MAJOR LEAGUE teams they were on, or what Negro League teams they were on? Â If you mean major leagues, there should be a file in the...
Does anyone have a dataset of Negro League players and the team they were on? Other information is not needed as long as I have those two facts. I am mainly...
If you just want an arbitrary winner, it's very easy to do it in the fashion that the hack does (which is just choosing the player with the highest ID, ...
3767
Tangotiger
tom@...
May 14, 2009 11:25 am
Great, thanks. Ok, so the cleanest, correct method would be to do: CAST(1000+g as CHAR) Tom ... The Book--Playing The Percentages In Baseball ...
No, I get the same results as before. CAST() seems to behave the same way Str() does for Access. From dev.mysql.com: The CAST() function takes a value of one...
3765
Tangotiger
tom@...
May 13, 2009 10:48 am
Ah-ha, so CHAR does not use any particular property. If you do this: CAST(g as CHAR(3) Then do you get the desired results? Tom ... The Book--Playing The...
These are the results if I use MAX(CONCAT(CAST(g as CHAR),"_",pos)) AS PrimPos yearid,playerid,PrimPos 1914,ruthba01,4_P 1915,ruthba01,32_P 1916,ruthba01,44_P ...
3763
Tangotiger
tom@...
May 11, 2009 8:53 pm
What happens if you change: MAX(CONCAT(1000 + CAST(g as CHAR),"_",pos)) AS PrimPos To: MAX(CONCAT(CAST(g as CHAR),"_",pos)) AS PrimPos Tom ... The...
I used CHAR(3) because the G column in the fielding table is smallint(3) in MySQL. I learned that I can actually change it to CAST(g as CHAR) and get the same...
3761
Tangotiger
tom@...
May 11, 2009 3:19 pm
Bryan, You don't have a tie-breaker in case someone plays the same number of games at two positions, do you? I would suggest that any alternative solutions be...
3760
Tangotiger
tom@...
May 11, 2009 2:50 pm
I'm surprised it works as you've laid it out (which is not to say that it's wrong, since I presume you've tested it). The reason I put "1000 + GP", is so that...
The query that is described is a neat trick and a good concept to know, but it's not a great permanent solution. ACCESS: SELECT yearID, teamID, Pos,...
I just figured it out: SELECT f2.yearid, f2.playerid, MID(MAX(CONCAT(1000 + CAST(f2.GP as CHAR(3)),"_",f2.pos)),6) AS PrimPos, Max(f2.GP) AS GP_Pos, SUM(f2.GP)...
3757
Tangotiger
tom@...
May 8, 2009 8:58 pm
Can you show us what functions you've tried? Here's a related one in Oracle I've used (for something else): substr(min(to_char(order_id + 90000,'00000') || ...
Is there a MySQL equivalent to this query? I'm struggling with converting it from Access to Mysql....
3755
Tangotiger
tom@...
May 4, 2009 10:42 am
Most programming languages and DB don't like column/field names that start with digits. Instead of 2B, 3B, rename them to B2, B3. Alternatively, if you give...
Could you point out a couple of the places where this occurs? sean 2009/5/1 htlfkbz <judsongreen@...> ... -- Sean Forman President, Sports Reference LLC ...
I did just find some help documentation. It appears that a double-quote is what you want to use. Vive la difference... select * from batting where "3B" like...
The problem is likely that the query doesn't like a field name beginning with a number. I'm not certain what the syntax with OpenOffice is, but try something...
Is anyone using openoffice with the Lahman database? I am having issues when I try to make a query with the 2B and 3B data, getting errors that I do not...
When a player plays for multiple teams in the same year, each season is listed, plus a sum of all which is noted with team titled TOT (for total) at Baseball...
Tom, I someone else was looking to do this and was using some kind of program to looked at the player's pitcher and then set the race accordingly. I look for...
Craig Depken and Jon Ford have a paper in the 2006 Journal of Socio Economics looking at the impact of race on allstar ballots. I can provide the data we used...
3744
Tangotiger
tom@...
Apr 16, 2009 3:05 pm
This post is only for those who sees this from a clinical rather than moral perspective. Please ignore this post is you are in the latter group. Can someone...
I just thought it would be cool if we all shared how we utilize the data we download. I started the website www.fan-exchange.com so fans can post their...
I have the 2009 mlb schedules availble to download on my site http://www.fan-exchange.com/mlb/schedule.asp Fields include homefranchid, awayfranchid and...
