Why 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!

So in MySQL it's possible to have a table:

create table fish (
created_date datetime not null
);

and do

insert into fish values ('0000-00-00');

This is valid.

wow. Wow. WOW.

Let's face it - it's just not a serious product.

Java will of course fail to convert '0000-00-00' into a valid java.sql.Timestamp

I am going to have to write code that runs on initialization of the context that fixes the data in the database because MySQL is such a pile of rubbish.