Boolean type on mysql

Question

I'm looking for a way to store boolean data in SQL. I couldn't find a boolean type in MySQL. I looked at the table on w3schools (SQL Data Types) and didn't find a boolean type.

But I get the information that TINYINT(1) is used for boolean types.

Is it true, or is there another option?

Answer 1

You can use BIT data type to store boolean data (like on T-SQL / SQL Server):

CREATE TABLE `table_name` (
    `column_name` BIT(1)
);

On MySQL the data types BOOL and BOOLEAN are also available:

CREATE TABLE `table_name` (
    `column_name1` BOOL,
    `column_name2` BOOLEAN
);

The BOOL and BOOLEAN data types are synonyms for TINYINT(1):

These types (BOOL and BOOLEAN) are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true.