mysql触发器分表

-- 创建主表
CREATE TABLE user (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

-- 创建子表
CREATE TABLE user_0 (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

CREATE TABLE user_1 (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

-- 创建触发器
DELIMITER $$
CREATE TRIGGER trg_insert_user
AFTER INSERT ON user
FOR EACH ROW
BEGIN
    IF NEW.id % 2 = 0 THEN
        INSERT INTO user_0 (id, name, email) VALUES (NEW.id, NEW.name, NEW.email);
    ELSE
        INSERT INTO user_1 (id, name, email) VALUES (NEW.id, NEW.name, NEW.email);
    END IF;
END$$
DELIMITER ;

-- 测试插入数据
INSERT INTO user (id, name, email) VALUES (1, 'Alice', 'alice@example.com');
INSERT INTO user (id, name, email) VALUES (2, 'Bob', 'bob@example.com');