![](https://csdnimg.cn/release/download_crawler_static/87137551/bg5.jpg)
2、创建数据库的语句
MySQL> connect shop;
已连接。
-- 用户表
create table users
(
id int auto_increment primary key,
name varchar(20),
passwd varchar(20),
sex varchar(2),
age int,
address varchar(50),
postcode varchar(6),
phone varchar(15),
adm int
);
-- 图书表
CREATE table books
(
id int auto_increment primary key,
name varchar(40),
author varchar(20),
publisher varchar(30),
price numeric(6,2)
);
-- 购物车表
create table storages
(
id int auto_increment primary key,
bookId int,
amount int,
inDate date
);
-- 订单表
create table `Order`
(
id int primary key auto_increment, -- 主键
onDate date , -- 下单日期