12Feb/090
Location, location, location
Iona: What are we watching?
Daddy: Hogan's Heroes.
Iona: Are they on a boat?
Daddy: No, they're in a POW camp.
Iona: Oh. New York is sort of like Texas.
10Feb/090
Misconceptions
Others (including the manual) have said it, and most who bother to read MySQL related blogs know it anyway, but:
* autoincrement does *not* have to be primary, or even unique. Just indexed.
* int(1) and int(100) hold the same range of values. The difference is how many zeros are added if zerofill is turned on.