[KLUG Programming] MySQL INT sizes

[Jamie McCarthy]

pikitfense at hotmail.com (Thomas Ross) writes:

> Ditto to everything Jamie said, with this note: isn't an int only
> -65535 to 65536 ?  Or is that called a smallint?

In MySQL-speak,

TINYINT      8 bits
SMALLINT    16 bits
MEDIUMINT   24 bits
INT         32 bits
BIGINT      64 bits

I don't know how other DBs define these things, sorry :)
-- 
  Jamie McCarthy
 http://mccarthy.vg/
  jamie at mccarthy.vg