mysql 分表脚本

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

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

-- 插入数据时根据用户ID进行分表
DELIMITER $$
CREATE PROCEDURE insert_user(IN p_id BIGINT, IN p_name VARCHAR(255), IN p_email VARCHAR(255))
BEGIN
    DECLARE table_name VARCHAR(255);
    IF p_id % 2 = 0 THEN
        SET table_name = 'user_0';
    ELSE
        SET table_name = 'user_1';
    END IF;
    SET @sql = CONCAT('INSERT INTO ', table_name, ' (id, name, email) VALUES (', p_id, ', ''', p_name, ''', ''', p_email, ''')');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END$$
DELIMITER ;

-- 调用存储过程插入数据
CALL insert_user(1, 'Alice', 'alice@example.com');
CALL insert_user(2, 'Bob', 'bob@example.com');