MySQL is a little funky, let's face it. Not always the most straightforward DB to deal with, but it certainly has its place. So I figured I'd share a little about some of my harder fought battles, so that you won't have to fight them yourself: