What is the difference between BIT and TINYINT in MySQL?

by

A TINYINT is an 8-bit integer value, a BIT field can store between 1 bit, BIT(1), and 64 bits, BIT(64). For a boolean values, BIT(1) is pretty common.

More Related Contents:

  1. How can I cast an int to a bit in MySQL 5.1?
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  4. Count the occurrences of DISTINCT values
  5. Codeigniter – multiple database connections
  6. Column count doesn’t match value count at row 1
  7. How to add levenshtein function in mysql?
  8. How to search JSON data in MySQL?
  9. MySQL > Table doesn’t exist. But it does (or it should)
  10. Is the primary key automatically indexed in MySQL?
  11. How do I modify a MySQL column to allow NULL?
  12. Connect to mysql in a docker container from the host
  13. Is there ANY_VALUE capability for mysql 5.6?
  14. Set NOW() as Default Value for datetime datatype?
  15. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  16. SQL DELETE with JOIN another table for WHERE condition
  17. How to connect to a MySQL Data Source in Visual Studio
  18. DOs and DONTs for Indexes [closed]
  19. How can I correct MySQL Load Error
  20. ‘Access denied for user ‘root’@’localhost’ (using password: NO)’
  21. MySQL treats ÅÄÖ as AAO?
  22. How can write queries in MySQL that can parse JSON data in a column?
  23. Count with IF condition in MySQL query
  24. MySQL Time Zones
  25. How to use django models with foreign keys in different DBs?
  26. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  27. Mysql select where not in table
  28. Using DISTINCT and COUNT together in a MySQL Query
  29. Which DATATYPE is better to use TEXT or VARCHAR?
  30. mySQL regex in the where clause

Leave a Comment