mysql实现多张表连接优化

-- 创建订单表
CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    total_amount DECIMAL(10, 2)
);

-- 创建客户表
CREATE TABLE customers (
    customer_id INT PRIMARY KEY,
    customer_name VARCHAR(100),
    customer_email VARCHAR(100)
);

-- 插入示例数据
INSERT INTO orders (order_id, customer_id, order_date, total_amount)
VALUES (1, 1, '2023-01-01', 100.00),
       (2, 2, '2023-01-02', 200.00),
       (3, 1, '2023-01-03', 150.00);

INSERT INTO customers (customer_id, customer_name, customer_email)
VALUES (1, 'Alice', 'alice@example.com'),
       (2, 'Bob', 'bob@example.com');

-- 内连接查询
SELECT o.order_id, o.order_date, o.total_amount, c.customer_name, c.customer_email
FROM orders o
INNER JOIN customers c ON o.customer_id = c.customer_id;