mysql有没有布尔值

-- 创建一个包含布尔值字段的表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    is_active TINYINT(1) DEFAULT 0 -- 使用TINYINT(1)表示布尔值，默认值为false
);

-- 插入数据
INSERT INTO users (username, is_active) VALUES ('Alice', 1); -- true
INSERT INTO users (username, is_active) VALUES ('Bob', 0); -- false

-- 查询数据
SELECT * FROM users;

SELECT id, username, IF(is_active = 1, 'true', 'false') AS active_status FROM users;

SELECT id, username, CASE WHEN is_active = 1 THEN 'true' ELSE 'false' END AS active_status FROM users;

INSERT INTO users (username, is_active) VALUES ('Charlie', IF('yes' = 'yes', 1, 0));

UPDATE users SET is_active = IF('no' = 'yes', 1, 0) WHERE id = 1;