| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Mojtaba Faridzad | Date: | June 10 2003 5:25pm |
| Subject: | INT type | ||
| View as plain text | |||
Hi, 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)? Thanks in advance
| 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 |