MySQL创建多个表代码
时间: 2024-03-01 20:49:35 浏览: 21
以下是在MySQL中创建多个表的示例代码:
```
CREATE TABLE customers (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(50)
);
CREATE TABLE orders (
id INT AUTO_INCREMENT PRIMARY KEY,
customer_id INT,
order_date DATE,
total DECIMAL(10,2),
FOREIGN KEY (customer_id) REFERENCES customers(id)
);
CREATE TABLE products (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
price DECIMAL(10,2)
);
CREATE TABLE order_items (
id INT AUTO_INCREMENT PRIMARY KEY,
order_id INT,
product_id INT,
quantity INT,
FOREIGN KEY (order_id) REFERENCES orders(id),
FOREIGN KEY (product_id) REFERENCES products(id)
);
```
这段代码创建了四个表:`customers`,`orders`,`products`,和 `order_items`。每个表都有自己的列和主键,以及与其他表的关系。例如,`orders`表中有一个`customer_id`列,它是一个外键,引用了`customers`表中的`id`列。`order_items`表中有`order_id`和`product_id`列,它们分别是指向`orders`表和`products`表的外键。