How to calculate size of INT(x) field
| From: | Richard Davey | Date: | Fri, 05 Mar 2004 11:29:03 +0000 |
| Subject: | How to calculate size of INT(x) field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33331@lists.php.net to get a copy of this message | ||
Hi all,
Sorry for such a newbie question! But I have been digging through the
O'Reilly MySQL book + MySQL Cookbook and cannot find an answer to what
I think is a very simple question:
When creating an unsigned INT field, how does the value in brackets
(if given) limit the size of the field? I.e. what is the difference in
possible maximum values held between an INT(10) and an INT(4)? I know
MySQL will create an INT(10) as standard but I'm not sure I need it to
be able to hold a number that high.
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html