创建两个有主键外键关系的数据表并且提供SQL语句并且提供数据内容
时间: 2023-06-11 21:10:09 浏览: 43
首先我们创建两个数据表,一个是订单表(Orders),另一个是订单详情表(OrderDetails),订单表的主键是订单号(OrderID),订单详情表的主键是订单详情号(OrderDetailID),订单详情表的外键是订单号(OrderID)。下面是创建表的SQL语句:
```SQL
CREATE TABLE Orders (
OrderID INT PRIMARY KEY,
CustomerName VARCHAR(50),
OrderDate DATE
);
CREATE TABLE OrderDetails (
OrderDetailID INT PRIMARY KEY,
ProductName VARCHAR(50),
Quantity INT,
Price DECIMAL(10,2),
OrderID INT,
FOREIGN KEY (OrderID) REFERENCES Orders(OrderID)
);
```
然后我们往这两个表中插入一些数据,下面是插入数据的SQL语句:
```SQL
INSERT INTO Orders (OrderID, CustomerName, OrderDate) VALUES (1, 'Tom', '2021-01-01');
INSERT INTO Orders (OrderID, CustomerName, OrderDate) VALUES (2, 'Jerry', '2021-01-02');
INSERT INTO Orders (OrderID, CustomerName, OrderDate) VALUES (3, 'Bob', '2021-01-03');
INSERT INTO OrderDetails (OrderDetailID, ProductName, Quantity, Price, OrderID) VALUES (1, 'Apple', 10, 2.5, 1);
INSERT INTO OrderDetails (OrderDetailID, ProductName, Quantity, Price, OrderID) VALUES (2, 'Banana', 20, 1.5, 1);
INSERT INTO OrderDetails (OrderDetailID, ProductName, Quantity, Price, OrderID) VALUES (3, 'Orange', 15, 3.0, 2);
INSERT INTO OrderDetails (OrderDetailID, ProductName, Quantity, Price, OrderID) VALUES (4, 'Grape', 5, 5.0, 2);
INSERT INTO OrderDetails (OrderDetailID, ProductName, Quantity, Price, OrderID) VALUES (5, 'Pineapple', 2, 10.0, 3);
```
这样我们就创建了两个数据表,并且往表中插入了一些数据。