| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Dan Nelson | Date: | June 10 2003 5:40pm |
| Subject: | Re: INT type | ||
| View as plain text | |||
In the last episode (Jun 10), Mojtaba Faridzad said: > I defined a field as INT type but when I checked in phpMyAdmin, it showed > INT(11). Still I cannot enter higher 2147483647 (signed int) in this field. > Does 11 mean that MySQL needs 11 bytes to keep it? I changed the length to > 2 (for example) but still I could save higher values such as 999 in it!!! > What does length mean in INT(length)? Display width. If you need to store a larger value, use a different integer type. http://www.mysql.com/doc/en/Column_types.html -- Dan Nelson dnelson@stripped
| Thread | ||
|---|---|---|
| • Fw: 2 questions about indexing and testing speed | Mojtaba Faridzad | 9 Jun |
| • arrangement of fields in a table | Mojtaba Faridzad | 9 Jun |
| • Re: arrangement of fields in a table | Jeremy Zawodny | 9 Jun |
| • Re: arrangement of fields in a table | Nils Valentin | 10 Jun |
| • Re: Fw: 2 questions about indexing and testing speed | Victoria Reznichenko | 10 Jun |
| • Re: Fw: 2 questions about indexing and testing speed | rich johnson | 10 Jun |
| • INT type | Mojtaba Faridzad | 10 Jun |
| • Re: INT type | Dan Nelson | 10 Jun |
| • RE: INT type | Mike Hillyer | 10 Jun |
| • Re: INT type | Mojtaba Faridzad | 10 Jun |
| • Re: INT type | Paul DuBois | 10 Jun |
| • Re: INT type | Dan Nelson | 10 Jun |
