-
Notifications
You must be signed in to change notification settings - Fork 9
/
Cart.sql
36 lines (27 loc) · 1.05 KB
/
Cart.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
create database Cart default charset=utf8;
use Cart;
create table goods (
goodsid int primary key auto_increment,
goodsname varchar(50) not null unique,
price double)engine=innodb default charset=utf8;
insert into goods(goodsid,goodsname,price) values(1,'张宇高数18讲',40.0);
insert into goods(goodsid,goodsname,price) values(2,'张宇1000题',45.0);
insert into goods(goodsid,goodsname,price) values(3,'恋练有词',47.0);
insert into goods(goodsid,goodsname,price) values(4,'李永乐660题',38.0);
insert into goods(goodsid,goodsname,price) values(5,'李永乐330题',28.0);
create table user (
un varchar(50) not null unique,
pwd varchar(50) not null,
phone varchar(30),
addr varchar(50))engine=innodb default charset=utf8;
create table cart (
goodsname varchar(50) not null ,
number int not null,
price double,
un varchar(50))engine=innodb default charset=utf8;
create table order_ (
id varchar(80) not null ,
un varchar(50) not null,
goodsname varchar(50) not null ,
number int not null,
price double not null)engine=innodb default charset=utf8;