MySQL INT meaning

by

The documentation seems pretty clear about this:

Numeric Type Attributes

MySQL supports an extension for optionally specifying the display
width of integer data types in parentheses following the base keyword
for the type. For example, INT(4) specifies an INT with a display
width of four digits. This optional display width may be used by
applications to display integer values having a width less than the
width specified for the column by left-padding them with spaces. (That
is, this width is present in the metadata returned with result sets.
Whether it is used or not is up to the application.)

The display width does not constrain the range of values that can be
stored in the column. Nor does it prevent values wider than the column
display width from being displayed correctly. For example, a column
specified as SMALLINT(3) has the usual SMALLINT range of -32768 to
32767, and values outside the range permitted by three digits are
displayed in full using more than three digits.

http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html

More Related Contents:

  1. What is the size of column of int(11) in mysql in bytes?
  2. What to do when you need integers larger than 20 digits on mysql?
  3. What is the MAX number if I store int(255) in MySQL?
  4. MySQL: Return 2 different result together
  5. Get top n records for each group of grouped results
  6. Joining three tables using MySQL
  7. Join tables with SUM issue in MYSQL
  8. Return default result for IN value regardless
  9. What is the MySQL VARCHAR max size?
  10. sql joins as venn diagram
  11. How can I join multiple SQL tables using the IDs?
  12. Maximum number of records in a MySQL database table
  13. How should I store GUID in MySQL tables?
  14. How to perform a mysqldump without a password prompt?
  15. MySQL, better to insert NULL or empty string?
  16. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  17. MySQL indexes – what are the best practices?
  18. Selecting random rows with MySQL
  19. JavaFX MySQL connection example please
  20. mysql select int as currency or convert int to currency format?
  21. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  22. Why do results from a SQL query not come back in the order I expect?
  23. MySQL combine two columns and add into a new column
  24. How does MySQL CASE work?
  25. MySql difference between two timestamps in days?
  26. Getting data for histogram plot
  27. How accurately should I store latitude and longitude?
  28. MySQL: LAST_INSERT_ID() returns 0
  29. XAMPP – Error: MySQL shutdown unexpectedly
  30. ERROR 1044 (42000): Access denied for ‘root’ With All Privileges

Leave a Comment