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 is delimiter in mysql stored procedure?

852

Is number a datatype in mysql?

892

Write a query to stop mysql in unix

993

How do I install mysql on windows 7?

930

How to make a copy values from one column to another in mysql?

970

What is procedures in mysql?

886

What is row level locking in mysql?

929

What is limit in mysql?

822

How do I select a database in mysql workbench?

937

What is information_schema in mysql?

929

How do you kill a long running query in mysql?

835

What is ddl, dml, and dcl?

927

How to calculate the difference between two dates?

976

What are Heap tables?

1471

Can we use mysql and mysqli together?

940