Shaun wrote:
>Hi,
>
>When I create a table using my ISP's web control panel and I create a column
>with a type of TINYINT it automatically creates a column with a value of
>TINYINT(4).
>
>After looking at the documentation on the MySQL site it is not exactly clear
>what this means:
>
>http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
>
>Is TINYINT(4) the same as an INT(4)?
>
>Thanks for your advice.
>
>
>
>
TINYINT(4) means a type that holds a value for -128 to 127 displayed
with max (4) character positions.
The part in parenthesis is the input/output display parameter, not the
number of bytes of storage.