int length

[sidsel]

I'm really confused about using int for declaring a mysql field. As I know a integer is 32 bit (4 bytes) right?

If you declare a mysql field like this "id int(4) unsigned NOT NULL auto_increment" does it mean that only 4 bits is used and I can have maximum 2⁴ = 16 rows or does it mean that it can hold maximum 4 digits = 9999 rows?

Explanation for dummies please 🙂

[drawmack]

in mysql int(4) = a four digit field.