mysql会员表如何分表

CREATE TABLE member_basic (
    id INT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(50),
    email VARCHAR(50),
    phone VARCHAR(20),
    create_time DATETIME
);

CREATE TABLE member_detail (
    id INT PRIMARY KEY,
    member_id INT,
    address TEXT,
    FOREIGN KEY (member_id) REFERENCES member_basic(id)
);

CREATE TABLE member_0 (
    id INT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(50),
    email VARCHAR(50),
    phone VARCHAR(20),
    address TEXT,
    create_time DATETIME
);

CREATE TABLE member_1 (
    id INT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(50),
    email VARCHAR(50),
    phone VARCHAR(20),
    address TEXT,
    create_time DATETIME
);

-- 以此类推，创建更多的分表

DELIMITER $$
CREATE FUNCTION get_member_table_name(member_id INT) RETURNS VARCHAR(20)
BEGIN
    DECLARE table_name VARCHAR(20);
    SET table_name = CONCAT('member_', member_id % 10);
    RETURN table_name;
END$$
DELIMITER ;

INSERT INTO (SELECT @table_name := get_member_table_name(id)) `@table_name` (id, username, password, email, phone, address, create_time)
VALUES (1, 'user1', 'pass1', 'user1@example.com', '1234567890', 'Address1', NOW());