I have a customerID column . Can i declare it as a tinyint . It would be a autoincremnting identity column.
I can see that tiny int stores
Integer data from 0 through 255. Storage size is 1 byte.
Does it mean that customerID's 256,257,258 ... cant be inserted and it only accepts till 255 number.
can it be explained what does 0 to 255 storage means for tinyint
and also storage for int with an example which is easy to understand.