daigo.org

As I ‘ve stated before, I’m switching from MySQL 4.1 to MySQL 5.0. I had a sql statement what used to work on 4.1 but stopped working and here is how I (and a little help from co-worker) fixed it:

SQL statement before (worked on 4.1 but gave error Query failed: Unknown column ‘player_info.team_id’ in ‘on clause in 5.0):

SELECT * FROM player_info, stats
JOIN teams ON player_info.team_id = teams.team_abbr
WHERE player_info.status = 1 AND stats.year = 2005
AND player_info.img_id = stats.img_id AND league_id = 1

ORDER BY player_info.team_id ASC

Fixed statement:

SELECT * FROM player_info, stats, teams
WHERE player_info.status = 1 AND stats.year = 2005
AND player_info.img_id = stats.img_id AND league_id = 1

AND player_info.team_id = teams.team_abbr
ORDER BY player_info.team_id ASC

I’m glad that it’s fixed!

This entry was posted on Tuesday, March 7th, 2006 at 03/07/2006 @ 12:01 pm and is filed under Linux, Mac, and LAMP Open Source. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.