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.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to