MySQL Workbench中的True / False数据类型

Hi I would like to know what datatype allows me to use the values: true or false in my table. I can choose BOOLEAN (or TINYINT) and use the values 1 and 0 but was just wondering about the values "true" and "false"

您好我想知道什么数据类型允许我使用值：我的表中的true或false。我可以选择BOOLEAN（或TINYINT）并使用值1和0但只是想知道值“true”和“false”

2 个解决方案

#1

9.1.6 Boolean Literals

9.1.6布尔文字

The constants TRUE and FALSE evaluate to 1 and 0, respectively. The constant names can be written in any lettercase.

常量TRUE和FALSE分别计算为1和0。常量名称可以用任何字母大写。

Reference: https://dev.mysql.com/doc/refman/5.7/en/boolean-literals.html

参考：https：//dev.mysql.com/doc/refman/5.7/en/boolean-literals.html

#2

You can use boolean in MySql

您可以在MySql中使用boolean

SQL DEMO

SQL DEMO

DROP TABLE IF EXISTS MyGuests;

CREATE TABLE MyGuests (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    test boolean
);

INSERT INTO MyGuests (test)
    VALUES (true);

SELECT * FROM MyGuests;

#1