2亿数据怎样存入mysql

-- 创建多个表
CREATE TABLE users_1 (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

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

-- 插入数据时根据id进行分片
DELIMITER $$
CREATE FUNCTION get_user_table_name(user_id INT) RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
    DECLARE table_name VARCHAR(255);
    IF user_id % 2 = 0 THEN
        SET table_name = 'users_1';
    ELSE
        SET table_name = 'users_2';
    END IF;
    RETURN table_name;
END$$
DELIMITER ;

-- 插入数据
INSERT INTO get_user_table_name(id) (id, name, email)
VALUES (1, 'Alice', 'alice@example.com');

-- 创建分区表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
)
PARTITION BY RANGE (id) (
    PARTITION p0 VALUES LESS THAN (50000000),
    PARTITION p1 VALUES LESS THAN (100000000),
    PARTITION p2 VALUES LESS THAN (150000000),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);