Explain the difference between BOOL, TINYINT and BIT?



Explain the difference between BOOL, TINYINT and BIT?..

Answer / amith

Prior to MySQL 5.0.3: those are all synonyms. After MySQL
5.0.3: BIT data type can store 8 bytes of data and should
be used for binary data.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to display top 10 rows in mysql?

0 Answers  


How do I change the max connections in mysql?

0 Answers  


What is row locking in mysql?

0 Answers  


Explain MySQL locks?

1 Answers  


How can I connect mysql database?

0 Answers  


What is difference between mysql and mysql server?

0 Answers  


What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.

6 Answers  


How can we get total number of records by query in mysql?

0 Answers  


How you can create a trigger in mysql?

0 Answers  


How to get current MySQL version?

0 Answers  


What are the different mysql database engines?

0 Answers  


How to get nth highest salary from table in a mysql?

0 Answers  


Categories