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 does mysql store data?

514


What is query log in mysql?

490


How to include numeric values in sql statements?

496


What does mysql flush hosts do?

468


How do I find mysql location?

479






How to enter boolean values in sql statements?

535


What is mysql architecture?

499


How to get data from mysql in php?

425


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.

580


What is mysql slow query?

514


What is mysql protocol?

453


What is 1nf 2nf 3nf?

493


how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

534


What are the difference between now and current_date in mysql?

641


What is difference between pdo and mysqli?

460