mysql怎么存bool

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    is_active TINYINT(1)
);

INSERT INTO example (is_active) VALUES (1); -- true
INSERT INTO example (is_active) VALUES (0); -- false

SELECT * FROM example;

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    is_active ENUM('false', 'true')
);

INSERT INTO example (is_active) VALUES ('true'); -- true
INSERT INTO example (is_active) VALUES ('false'); -- false

SELECT * FROM example;

# 示例代码（Python）
result = cursor.execute("SELECT is_active FROM example WHERE id = 1")
is_active = result.fetchone()[0]
if is_active == 1:
    is_active = True
else:
    is_active = False

-- 示例代码
INSERT INTO example (is_active) VALUES ('true'); -- 正确
INSERT INTO example (is_active) VALUES ('invalid'); -- 错误