mysql 分表唯一主键

-- 创建分表
CREATE TABLE user_0 (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id VARCHAR(255) NOT NULL,
    name VARCHAR(255) NOT NULL,
    UNIQUE (user_id)
);

CREATE TABLE user_1 (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id VARCHAR(255) NOT NULL,
    name VARCHAR(255) NOT NULL,
    UNIQUE (user_id)
);

-- 插入数据
DELIMITER $$
CREATE PROCEDURE insert_user(IN user_id VARCHAR(255), IN name VARCHAR(255))
BEGIN
    DECLARE table_name VARCHAR(255);
    SET table_name = CONCAT('user_', LEFT(user_id, 1));
    SET @sql = CONCAT('INSERT INTO ', table_name, ' (user_id, name) VALUES (?, ?)');
    PREPARE stmt FROM @sql;
    EXECUTE stmt USING user_id, name;
    DEALLOCATE PREPARE stmt;
END$$
DELIMITER ;

CALL insert_user('123456', 'Alice');