Explain the difference between BOOL, TINYINT and BIT?

Question Posted / amith

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

More MySQL Interview Questions

What are the differences between mysql vs sql server?

How to check if value already exists in mysql database in php?

Explain about reporting services of MYSQL?

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

What is mysql default database?

What tools available for managing mysql server?

What is the purpose of using ifnull() function?

how to Return total number of rows.

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

What is the difference between char and varchar?

Is Mysql query is case sensitive?

How do I delete a row in mysql?

For more MySQL Interview Questions Click Here