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
How does mysql store data?
What is query log in mysql?
How to include numeric values in sql statements?
What does mysql flush hosts do?
How do I find mysql location?
How to enter boolean values in sql statements?
What is mysql architecture?
How to get data from mysql in php?
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.
What is mysql slow query?
What is mysql protocol?
What is 1nf 2nf 3nf?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What are the difference between now and current_date in mysql?
What is difference between pdo and mysqli?