Mysql boolean setting_mysql

Mysql boolean settings bitsCN.com

Mysql boolean settings

MySQL does not have the boolean type. This is also a strange phenomenon. Example:

Create table xs

(

Id int primary key,

Bl boolean

)

In this way, you can create a table successfully, but check the statement after the table is created, and you will find that mysql replaces it

Tinyint (1 ). That is to say, mysql has boolean = tinyInt.

Boolean type

When MYSQL saves a BOOLEAN value, 1 indicates TRUE, and 0 indicates FALSE. the type of boolean in MySQL is tinyint (1 ),

MySQL has four constants: true, false, TRUE, and FALSE, which represent 1, 0, 1, and 0, respectively.

BitsCN.com