Explain the difference between BOOL, TINYINT and BIT?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I tune a mysql query?

638


How does mysql store dates?

667


What is the difference between a database and a table?

687


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1995


How do I start mysql from command line?

697






How do I start mysql?

645


What is the use of mysqli_connect in php?

639


What is difference between oracle and mysql?

661


What is mysql root?

684


How do you connect MySQL database with PHP?

700


How do I check mysql version?

683


Why do we write stored procedures?

648


How large can a mysql table be?

658


What is the difference between heap table and temporary table?

833


Explain the different types of mysql joins.

646