armtuk: Cheetah (Default)
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!
armtuk: Cheetah (Default)
If I read this post on the MySQL Forum correctly - it appears that MySQL Doesn't roll back any transactions that were started by a connection that terminated prematurely. This means that any program that exists in the middle of a transaction can leave locks on the database open, and prevent other queries from running. Has MySQL not heard of MVCC?

MySQL News

Dec. 18th, 2008 12:56 am
armtuk: Cheetah (Default)
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.

Profile

armtuk: Cheetah (Default)
armtuk

April 2017

S M T W T F S
      1
2345678
9101112131415
16171819 202122
23242526272829
30      

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 20th, 2017 12:50 pm
Powered by Dreamwidth Studios