mysql插入关联数据

-- 创建 Customers 表
CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    CustomerName VARCHAR(255) NOT NULL
);

-- 创建 Orders 表
CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);

-- 插入 Customers 数据
INSERT INTO Customers (CustomerID, CustomerName) VALUES
(1, 'Alice'),
(2, 'Bob');

-- 插入 Orders 数据，关联到 Customers 表
INSERT INTO Orders (OrderID, CustomerID, OrderDate) VALUES
(101, 1, '2023-04-01'),
(102, 1, '2023-04-05'),
(103, 2, '2023-04-10');

SET FOREIGN_KEY_CHECKS=0;
-- 插入数据
SET FOREIGN_KEY_CHECKS=1;

INSERT INTO Customers (CustomerID, CustomerName) VALUES (3, 'Charlie');
INSERT INTO Orders (OrderID, CustomerID, OrderDate) VALUES (104, 3, '2023-04-15');