A Little Noise

Month: February 2009

  • 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.

  • 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.