B站黑马测试第二篇P215视频数据库SQL语句‘自关联查询_数据准备‘代码

drop table if exists areas;
create table areas (
aid int primary key,
atitle varchar(20),
pid int
);
insert into areas values
('130000','河北省',NULL),
('130100','石家庄市','130000'),
('130400','邯郸市','130000'),
('130600','保定市','130000'),
('130700','张家口市','130000'),
('130800','承德市','130000'),
('410000','河南省',NULL),
('410100','郑州市','410000'),
('410300','洛阳市','410000'),
('410500','安阳市','410000'),
('410700','新乡市','410000'),
('410800','焦作市','410000'),
('410101','中原区','410100'),
('410102','二七区','410100'),
('410301','洛龙区','410300');

 以上代码为B站黑马“软件测试从入门到自动化测试工程师”,第二篇P215视频,自关联查询_数据准备'代码.

接下来我会记录我在学习中遇到的问题,大家一起共勉!!

引用资料

B站黑马“软件测试从入门到自动化测试工程师”