MySQL建表/*创建supermarket库*/
create database supermarket;
use supermarket;
/*创建members表*/
create table members (
mid char(3) primary key,
mname varchar(10),
mnumber char(18),
mtel varchar(8),
viplevel varchar(10));
/*创建goods表*/
create table goods (
gid char(3) primary key,
gname varchar(20) not null,
gtype varchar(10) not null,
gprice decimal(7,2),
gplace varchar(10));
/*创建orders表*/
create table orders (
oid char(4),
gid char(3),
quantity int,
time datetime,
mid char(3),
pay char(2));
/*创建suppliers表*/
create table suppliers (
sid char(3),
sname varchar(10),
cid char(3),
sprice decimal(7,2));
/*创建buys表*/
create table buys (
bid char(3),
btime datetime,
cid char(3),
bquantity int,
sid char(3));
/*创建vipclass表*/
create table vipclass (
vipname varchar(10));
insert members values
('001','赵成志','530211199612130017','18956564123','普通'),
('002','周娟娟','531211199612130217','18556569126','白银'),
('003','李一三','52021119961213001X','19950004103','黄金'),
('004','李云龙','530211199812130024','18056564123','普通'),
('005','王婷','430211200112130019','13888979756','黄金');
insert goods values
('101','美丽香皂','日用品',5.5,'广州越秀区'),
('102','洗澡毛巾','日用品',9.5,'江苏苏州'),
('103','快餐面','食品',9.9,'昆明杨林'),
('104','茅台','烟酒',1999,'贵州贵阳'),
('105','云烟','烟酒',13,'云南玉溪'),
('106','大白菜','蔬菜',3.5,'曲靖'),
('107','小龙虾',null,68.8,'广西北海'),
('108','辣条','食品',8.8,'昆明石林'),
('109','儿童遥控车','玩具',99,'昆明官渡区'),
('121','洗脸毛巾','日用品',6.5,'云南昆明')
('888','会员卡','权益',0,'云南昆明);
insert orders values /*该表是用户购买订单,最后列是否支付*/
('2201','104',3,'2022-04-02','003','是'),
('2202','103',2,'2022-04-05','004','是'),
('2203','105',11,'2022-04-07','002','是'),
('2204','108',10,'2022-04-09','001','是'),
('2205','107',3,'2022-04-10','002','是'),
('2206','104',2,'2022-04-12','003','否'),
('2207','109',1,'2022-04-13','004','是'),
('2208','106',3,'2022-04-12','005','是'),
('2211','108',7,'2022-03-22','001','是'),
('2212','105',2,'2022-03-24','005','否');
insert suppliers values
('201','昆明沃尔玛','101',4.2), /* 4.2是进货价,以下同*/
('201','昆明沃尔玛','102',7.8),
('201','昆明沃尔玛','106',2.3),
('202','昆明家乐福','103',7.7),
('203','昆明友谊商贸有限公司','104',1688),
('204','昆明诚信烟草','105',10.58),
('202','昆明家乐福','107',49.8),
('205','昆明咚咚食品','108',2.2),
('206','上海迪斯尼玩具','109',69.8);
insert buys values /*该表是进货记录表*/
('401','2022-03-22','101',25,'201'),
('402','2022-03-22','102',30,'201'),
('403','2022-03-23','101',15,'201'),
('404','2022-04-01','103',25,'202'),
('405','2022-04-03','104',30,'203'),
('406','2022-04-05','105',27,'204'),
('407','2022-04-05','106',25,'201'),
('408','2022-04-09','107',35,'202'),
('409','2022-04-10','108',93,'205'),
('410','2022-04-11','109',3,'206'),
('411','2022-04-11','104',25,'203');
最新发布
本文探讨了Vue开发者在深入学习过程中遇到的问题，强调了理解基础和算法的重要性。作者反思了对不熟悉内容的浅尝辄止，并分享了通过系统学习算法和刷题来提升底层理解的经验。
扫一扫
29万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
