mysql如何拆分表

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255),
    created_at TIMESTAMP
);

CREATE TABLE users_202301 (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255),
    created_at TIMESTAMP
);

CREATE TABLE users_202302 (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255),
    created_at TIMESTAMP
);

-- 继续创建其他月份的分片表...

DELIMITER //

CREATE PROCEDURE insert_user(
    IN p_id INT,
    IN p_name VARCHAR(255),
    IN p_email VARCHAR(255),
    IN p_created_at TIMESTAMP
)
BEGIN
    DECLARE shard_table VARCHAR(255);
    
    SET shard_table = CONCAT('users_', YEAR(p_created_at), LPAD(MONTH(p_created_at), 2, '0'));
    
    SET @sql = CONCAT('INSERT INTO ', shard_table, ' (id, name, email, created_at) VALUES (?, ?, ?, ?)');
    PREPARE stmt FROM @sql;
    EXECUTE stmt USING p_id, p_name, p_email, p_created_at;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE get_user_by_id(
    IN p_id INT
)
BEGIN
    DECLARE shard_table VARCHAR(255);
    
    SET shard_table = CONCAT('users_', YEAR((SELECT created_at FROM users WHERE id = p_id)), LPAD(MONTH((SELECT created_at FROM users WHERE id = p_id)), 2, '0'));
    
    SET @sql = CONCAT('SELECT * FROM ', shard_table, ' WHERE id = ?');
    PREPARE stmt FROM @sql;
    EXECUTE stmt USING p_id;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;