MySQL语法中创建两个相关表代码示例

//客户表(customers) CREATE TABLE customers ( customer_id I

//客户表(customers)
CREATE TABLE customers (
    customer_id INT PRIMARY KEY,
    customer_name VARCHAR(50)
);

//订单表(orders)
CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    order_date DATE,
    customer_id INT,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);