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 - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

1 Answers  


What is csv?

1 Answers  


What is a tinyint in mysql?

1 Answers  


What is key in mysql?

1 Answers  


How do you index just the first four bytes of the column?

2 Answers  


What is a delimiter in mysql?

1 Answers  


What are the difference between and myisam and innodb?

1 Answers  


Is mysql and sql are same?

1 Answers  


Is there an object-oriented version of MySQL library functions?

1 Answers  


Where is the mysql data directory?

1 Answers  


Is SET Command is SQL Statement..?

4 Answers   BitWise,


What is mysql sleep process?

1 Answers  


Categories