Things you can do in MySQL
Feb. 23rd, 2009 03:45 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
armtukWhy can't I do this?
update sp_college_game n set n.game_status_ev_id=6 where n.college_game_id in (select a.college_game_id from sp_college_game a, sp_college_playoff_entry b where a.college_game_id = b.game_id)
It's not that hard! Oracle will let me do that, and so will PostgreSQL, but MySQL is too crap.
Did I mention that you have to a stupid idiot to walk outside to talk on your cell phone with nothing more than a long sleeve T-Shirt on! It's frikin cold!
update sp_college_game n set n.game_status_ev_id=6 where n.college_game_id in (select a.college_game_id from sp_college_game a, sp_college_playoff_entry b where a.college_game_id = b.game_id)
It's not that hard! Oracle will let me do that, and so will PostgreSQL, but MySQL is too crap.
Did I mention that you have to a stupid idiot to walk outside to talk on your cell phone with nothing more than a long sleeve T-Shirt on! It's frikin cold!
