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

Explain federated tables?

3 Answers   Tech Mahindra,


What is mysql_query?

0 Answers  


Can't connect mysql server on localhost?

0 Answers  


Why do we use the mysql database server?

0 Answers  


How to add a new column to an existing table in mysql?

0 Answers  


Is mysqli deprecated?

0 Answers  


How do I select a database in mysql workbench?

0 Answers  


Describe mysql transaction properties.

0 Answers  


How set mysql root password?

0 Answers  


What is a table schema?

0 Answers  


How do I truncate all tables in mysql?

0 Answers  


What is database engine in mysql?

0 Answers  


Categories