mysql 右连接写法

SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name = table2.column_name;

SELECT customers.name, orders.order_id
FROM customers
RIGHT JOIN orders
ON customers.customer_id = orders.customer_id;

-- 创建示例表
CREATE TABLE customers (
    customer_id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    amount DECIMAL(10, 2)
);

-- 插入示例数据
INSERT INTO customers (customer_id, name) VALUES (1, 'Alice'), (2, 'Bob');
INSERT INTO orders (order_id, customer_id, amount) VALUES (101, 1, 100.00), (102, 3, 200.00);

-- 执行右连接查询
SELECT customers.name, orders.order_id
FROM customers
RIGHT JOIN orders
ON customers.customer_id = orders.customer_id;