True/False vs 0/1 in MySQL

by

Some “front ends”, with the “Use Booleans” option enabled, will treat all TINYINT(1) columns as Boolean, and vice versa.

This allows you to, in the application, use TRUE and FALSE rather than 1 and 0.

This doesn’t affect the database at all, since it’s implemented in the application.

There is not really a BOOLEAN type in MySQL. BOOLEAN is just a synonym for TINYINT(1), and TRUE and FALSE are synonyms for 1 and 0.

If the conversion is done in the compiler, there will be no difference in performance in the application. Otherwise, the difference still won’t be noticeable.

You should use whichever method allows you to code more efficiently, though not using the feature may reduce dependency on that particular “front end” vendor.

More Related Contents:

  1. Which MySQL data type to use for storing boolean values
  2. MySQL OPTIMIZE all tables?
  3. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  4. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  5. Strip last two characters of a column in MySQL
  6. Linux shell script for database backup
  7. How can a query multiply 2 cell for each row MySQL?
  8. apache mysql – “packets out of order” on 3306
  9. find number of rows in returned mysql result (nodejs)
  10. What is difference between storing data in a blob, vs. storing a pointer to a file?
  11. How to estimate SQL query timing?
  12. Rails select random record
  13. mysql select distinct rows into a comma delimited list column
  14. Access mysql running on localhost from minikube
  15. MySQL fulltext search – Only results that contain all words
  16. How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password?
  17. MySQL query to select results with auto increment as a new column added in the result
  18. mysql UPDATE statement – overhead for same values?
  19. How do I limit the number of rows per field value in SQL?
  20. MySQL: Left join and column with the same name in different tables
  21. Disadvantages of quoting integers in a Mysql query?
  22. MySQL scripts in docker-entrypoint-initdb are not executed
  23. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  24. How do I add more members to my ENUM-type column in MySQL?
  25. How to import a csv file into MySQL workbench?
  26. MySql – Update table using select statment from same table
  27. Optimizing MySQL for ALTER TABLE of InnoDB
  28. MySQL: SELECT from another server
  29. What is the jdbc driver “org.gjt.mm.mysql.Driver” for?
  30. How to allow fulltext searching with hyphens in the search query

Leave a Comment