//客户表(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) );
MySQL语法中创建两个相关表代码示例
//客户表(customers) CREATE TABLE customers ( customer_id I