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

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  


What are the two types of queries?

0 Answers  


How to create a new view in mysql?

0 Answers  


Is foreign key indexed mysql?

0 Answers  


What is innodb mysql?

0 Answers  






How do I switch users in mysql?

0 Answers  


How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,


What are date and time data types?

0 Answers  


What are the difference between and myisam and innodb?

0 Answers  


What are all the Common SQL Function?

0 Answers  


Why we use mysql workbench?

0 Answers  


Is mysql good for big data?

0 Answers  


Categories