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

What is foreign key in mysql?

0 Answers  


Can you tell how to find the number of rows in a resultset using php?

0 Answers  


Is mariadb better than mysql?

0 Answers  


What can you do with mysql?

0 Answers  


For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  






What is procedure in mysql?

0 Answers  


how to connect a php script with the mysql database?

0 Answers  


How to display nth highest salary from a table in a mysql query?

0 Answers  


How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

0 Answers  


What is database engine in mysql?

0 Answers  


What is mysql data directory? How to determine the location of the data directory?

0 Answers  


How do you create a primary key?

0 Answers  


Categories