如何在MySQL表中创建布尔列？

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    is_active TINYINT(1) DEFAULT 0, -- 默认值为false
    name VARCHAR(255) NOT NULL
);

ALTER TABLE example_table
ADD COLUMN is_active TINYINT(1) DEFAULT 0;

INSERT INTO example_table (name, is_active) VALUES ('Alice', 1); -- true
INSERT INTO example_table (name) VALUES ('Bob'); -- false，默认值

SELECT * FROM example_table;

INSERT INTO example_table (name, is_active) VALUES ('Charlie', 2); -- 错误

UPDATE example_table SET is_active = 3 WHERE id = 1; -- 错误

INSERT INTO example_table (name, is_active) VALUES ('Charlie', 1); -- 正确

UPDATE example_table SET is_active = 0 WHERE id = 1; -- 正确

SELECT * FROM example_table WHERE is_active = 'true'; -- 错误

SELECT * FROM example_table WHERE is_active = 1; -- 正确