int(11) vs. int(anything else)

by

The x in INT(x) has nothing to do with space requirements or any other performance issues, it’s really just the display width. Generally setting the display widths to a reasonable value is mostly useful with the UNSIGNED ZEROFILL option.

//INT(4) UNSIGNED ZEROFILL
0001
0002 
...
0099
...
0999
...
9999
...
10000

//INT(2) UNSIGNED ZEROFILL
01
02 
...
09
...
99
...
100

Without the UNSIGNED ZEROFILL option the value will be left-padded with spaces to the appropriate display width.

//INT(4)
   1
   2 
...
  99
...
 999
...
9999
...
10000

//INT(2)
 1
 2 
...
 9
...
99
...
100

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. Find duplicate records in MySQL
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. Difference between float and decimal data type
  11. Parse date in MySQL
  12. mysql dynamic query in stored procedure
  13. MySQL incorrect key file for tmp table when making multiple joins
  14. Sort by order of values in a select statement “in” clause in mysql
  15. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  16. How to cast DATETIME as a DATE in mysql?
  17. ORDER BY date and time BEFORE GROUP BY name in mysql
  18. Does the order of conditions in a WHERE clause affect MySQL performance?
  19. Difference between these two joining table approaches?
  20. MySQL INT meaning
  21. Get total number of rows when using LIMIT? [duplicate]
  22. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  23. MySQL export into outfile : CSV escaping chars
  24. Simple Random Samples from a MySQL Sql database
  25. MySQL Select minimum/maximum among two (or more) given values
  26. MySQL: Many tables or many databases?
  27. Select only last value using group by at mysql
  28. MySQL OPTIMIZE all tables?
  29. What’s mysql’s “BETWEEN” performance over..?
  30. mysql double-quoted table names

Leave a Comment