Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data

Explain the difference between BOOL, TINYINT and BIT?

Question Posted / amith

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

Please Help Members By Posting Answers For Below Questions

What are the functions of mysql?

983

What is mvcc in mysql?

1066

What is the current root password of mysql?

964

How do I backup mysql database on linux?

969

What is striped backup

2287

What is difference between oracle and mysql?

987

How Switch (select or use) to a database.

1117

What are the types of queries?

982

How to include character strings in sql statements?

1033

How do I edit a table in mysql workbench?

891

What is 'mysqlshow'?

1115

List some mysql advantages and disadvantages?

1010

What ascii 31?

1015

Write a query to display even rows in student table using mysql?

939

Consider you have the following three tables which have to be linked together.

937