drop table if exists category;
create table category(
id int unsigned primary key auto_increment,
typeId int,
cateName varchar(10)
);
insert into category values
(0, 001,'一次性口罩'),
(0, 002,'KN95口罩'),
(0, 003,'N95口罩'),
(0, 004,'医用口罩');
drop table if exists goods;
create table goods(
id int unsigned primary key auto_increment,
goodsName varchar(10),
price int,
num int,
company varchar(20),
remark varchar(20),
typeId int
);
insert into goods values
(0,'三奇',25,108,'某东','三奇3Q口罩',4),
(0,'振德',20,150,'x宝','振德一次性口罩',1),
(0,'袋鼠医生',30,180,'并夕夕','袋国医生医用口罩',4),
(0,'京东京造',139,100,'某东',nulL,null),
(0,'闪电卫士',77,160,'x宝','闪电卫士一次性口罩',1),
(0,'安克林',159, 190,'某东','安克林KN95级口罩',2),
(0,'科西诺',30,100,'x宝','科西诺三层防护口單',2),
(0,'维德医生',23,155,'并夕夕','维德成人医用口罩',4),
(0,'庭七',110,260,'某东','医用一次性口罩',1),
(0,'倍舒特',72,190,'x宝','三层防护一次性口罩医用口罩',4),
(0,'中服绿盾',110,50,'某东','',null),
(0,'惠寻',25,130,'并夕夕','惠寻一次性口罩',1);
以上代码为B站黑马“软件测试从入门到自动化测试工程师”,第二篇P206视频,关联查询_数据准备'代码.
接下来我会记录我在学习中遇到的问题,大家一起共勉!!
参考资料