Archive for February, 2008

Dream Job?

Thursday, February 28th, 2008

I think so.? I love tattoos.? I even have one and want more.? But I got to thinking about job of being a tattoo artist.? There are just so many pluses that, if I had the talent, it could be my dream job.? As I see it, you get to do creative, artistic work on some of the most diverse section of society.? You work in small (relatively) achievable chunks and as soon as you’re finished, someone (usually) tells you how beautiful your work is, how talented you are and what a big difference your creation will make in their life.? I’m sure there are some downsides, but I’m ignoring those.

OK…I’ve decided.? If I ever grow up, I wanna be a tattoo artist!

OK…I don’t understand it

Wednesday, February 27th, 2008

If you have read my previous two posts, you know that I was experiencing some anomalies with MySQL MERGE tables.? Well, since the original discovery of the anomaly, we dropped and recreated the schema and now it’s gone.? It functions as I thought it should have in the first place, ie. each subtable is directly queriable and updatable.? The only thing I can think of is we screwed up somethng in the original create MERGE statement that was weird, although I can imagine what it is.

Update on interesting MySQL tidbit

Tuesday, February 26th, 2008

After more experimentation, I found that you can, in fact, query one of the subtables in a MyISAM MERGE table but not a count.? I think this is even more odd.? I can get at the data, but I can’t find out how much there is.

Interesting MySQL Tidbit

Tuesday, February 26th, 2008

If you are a geek like me and are using MySQL (The greatest database going), here is an interesting tidbit I discovered. If you create a MYISAM MERGE table merging several identical subtables, you can still insert data directly into the subtables, but you cannot select data directly out of them. For that, you must now go through the merge table. Interesting.

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!