mysql 分表还是分区

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

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

-- 插入数据
INSERT INTO user_1 (id, name, email) VALUES (1, 'Alice', 'alice@example.com');
INSERT INTO user_2 (id, name, email) VALUES (2, 'Bob', 'bob@example.com');

-- 创建分区表
CREATE TABLE order (
    id INT PRIMARY KEY,
    order_date DATE,
    amount DECIMAL(10, 2)
) PARTITION BY RANGE (YEAR(order_date)) (
    PARTITION p0 VALUES LESS THAN (2020),
    PARTITION p1 VALUES LESS THAN (2021),
    PARTITION p2 VALUES LESS THAN (2022),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

-- 插入数据
INSERT INTO order (id, order_date, amount) VALUES (1, '2020-01-01', 100.00);
INSERT INTO order (id, order_date, amount) VALUES (2, '2021-02-02', 200.00);