MySql: Tinyint (2) vs tinyint(1) – what is the difference?

by

The (m) indicates the column display width; applications such as the MySQL client make use of this when showing the query results.

For example:

| v   | a   |  b  |   c |
+-----+-----+-----+-----+
| 1   | 1   |  1  |   1 |
| 10  | 10  | 10  |  10 |
| 100 | 100 | 100 | 100 |

Here a, b and c are using TINYINT(1), TINYINT(2) and TINYINT(3) respectively. As you can see, it pads the values on the left side using the display width.

It’s important to note that it does not affect the accepted range of values for that particular type, i.e. TINYINT(1) still accepts [-128 .. 127].

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Which MySQL data type to use for storing boolean values
  3. Best data type to store money values in MySQL
  4. Best data type for storing currency values in a MySQL database
  5. What is difference between storing data in a blob, vs. storing a pointer to a file?
  6. Equivalent of explode() to work with strings in MySQL
  7. 1064 error in CREATE TABLE … TYPE=MYISAM
  8. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  9. MySQL DELETE FROM with subquery as condition
  10. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  11. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  12. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  13. How to use LOAD_FILE to load a file into a MySQL blob?
  14. Determine Rank based on Multiple Columns in MySQL
  15. Relational database design multiple user types
  16. Checking multiple columns for one value
  17. What is better in MYSQL count(*) or count(1)?
  18. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  19. How to deploy local MySQL database to Heroku
  20. How to lock a single row
  21. MySQL Cannot drop index needed in a foreign key constraint
  22. MySQL Insert & Joins
  23. How to join two tables using a comma-separated-list in the join field
  24. Does MySQL included with MAMP not include a config file?
  25. How to regex in a MySQL query
  26. How do I write an SP in phpMyAdmin (MySQL)?
  27. Syntax error on MERGE statement
  28. Equivalent of MSSQL IDENTITY Column in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment