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

Difference between CHAR and VARCHAR?

How many concurrent queries can mysql handle?

What is mysql server used for?

Why MySQL is used?

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

How to get help information from the server?

How to get the number of rows selected or affected by a sql statement?

How to create a trigger in mysql?

I want to find out all databases starting with ‘test’, I have access to?

What is the phantom problem?

What is triggers?

What are the differences between drop a table and truncate a table?

For more MySQL Interview Questions Click Here