mysql hash分表

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

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

-- 插入数据
DELIMITER $$
CREATE PROCEDURE insert_user(IN user_id INT, IN user_name VARCHAR(255), IN user_email VARCHAR(255))
BEGIN
    DECLARE table_name VARCHAR(255);
    SET table_name = CONCAT('users_', user_id % 2);
    SET @sql = CONCAT('INSERT INTO ', table_name, ' (id, name, email) VALUES (', user_id, ', "', user_name, '", "', user_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');