Month: April 2009
-
MySQL Workbench: My Impressions
I’ve been using the MySQL Workbench 5.1 beta for the past few days now, and I’m wondering how I designed databases without it. Okay, so that’s a pretty strong statement, but I’m genuinely happy with it. 5.1 has fixed my main problem with 5.0, in that the EER diagram mode was horribly slow to render,…
-
Extracting a Database From a mysqldump File
Restoring a single database from a full dump is pretty easy, using the mysql command line client’s –one-database option: mysql> mysql -u root -p –one-database db_to_restore < fulldump.sql But what if you don’t want to restore the database, you just want to extract it out of the dump file? Well, that happens to be easy…
-
Yohosie at The Tote, with Boom Pretty
This makes the second show of Yohosie‘s May residency at The Tote, and they’re rocking it. First band up was Innerspace, with their rather loud wakeup for the neighbours. Sadly, they were a bit too loud for the small venue, I couldn’t really hear their music. Going by the recordings available on their MySpace, I…
-
Don’t put a NULL in the IN clause in 5.1
There seems to be an optimizer problem in 5.1, if you put a NULL in the IN clause of a SELECT. For example, given the following table: CREATE TABLE foo ( a INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (a) ); Compare these two EXPLAINs: mysql> EXPLAIN * FROM foo WHERE a IN (160000, 160001, 160002)\G…
-
V Festival
While not as popular as its bigger cousin Big Day Out, V Festival always manages to sign on the big names, this year being no exception. While the day didn’t start out spectacularly (it seems one of the promoters forgot to pass the door list I was on over to Ticketek), the show itself went…
-
JOIN and comma precedence
Here’s a little something that might trip you up occasionally. Have a look at this test scenario: USE test; DROP TABLE IF EXISTS a; DROP TABLE IF EXISTS b; DROP TABLE IF EXISTS c; CREATE TABLE a ( a INT ); CREATE TABLE b ( b INT ); CREATE TABLE c ( c INT );…