Archive for December, 2005

It’s not Oregon Trail

Thursday, December 29th, 2005

During a recent conversation I was asked if MySQL is capable of converting numbers to words. Basically converting 2 into ‘two’. The answer is, of course no. However it did remind me of an old PC game I used to play in grade school (yes I’m that young). Here is your moment of nostalgia:

Number Munchers!

The lost art of the join.

Saturday, December 17th, 2005

One of the things I always like about growing up with MySQL is that I had to learn joins. There was no sub select to fall back on if I couldn’t get a join to work correctly. With MySQL 4.1 the norm and 5.0 quickly on it’s heels I see more and more problems that people are solving with sub selects that could as easily be solved with joins if they knew how to write them. In my experience joins are faster and easier to optimize than sub selects but I seem to be in the minority now with that idea.

Don’t worry join syntax. I won’t forget you!

Flashing

Thursday, December 1st, 2005

Today’s out of context quote. I baited this one but it’s still funny:

Eric Bergen: are you flashing people?
Jeremy Cole: i flashed justin