Hobos Landing

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!

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.

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.

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.