Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
jackfrued
GitHub Repository: jackfrued/Python-100-Days
 Path: blob/master/Day36-45/code/mooc_create_and_init.sql
2926 views
1
drop database if exists mooc1706;

2
create database mooc1706 default charset utf8;

3


4
use mooc1706;

5


6
create table tb_course_catalog

7
(

8
catid integer not null auto_increment,

9
catname varchar(20) not null,

10
catparent integer,

11
primary key (catid)

12
);

13


14
alter table tb_course_catalog add constraint fk_catalog_parent 

15
foreign key (catparent) references tb_course_catalog(catid) 

16
on delete cascade 

17
on update cascade;

18


19
insert into tb_course_catalog values (default, '前端开发', null);

20
insert into tb_course_catalog values (default, '后端开发', null);

21
insert into tb_course_catalog values (default, '移动开发', null);

22
insert into tb_course_catalog values (default, '数据库', null);

23
insert into tb_course_catalog values (default, '云计算&大数据', null);

24
insert into tb_course_catalog values (default, '运维&测试', null);

25
insert into tb_course_catalog values (default, 'UI设计', null);

26


27


28
insert into tb_course_catalog values (default, 'HTML/CSS', 1);

29
insert into tb_course_catalog values (default, 'JavaScript', 1);

30
insert into tb_course_catalog values (default, 'jQuery', 1);

31
insert into tb_course_catalog values (default, 'HTML5', 1);

32
insert into tb_course_catalog values (default, 'CSS3', 1);

33
insert into tb_course_catalog values (default, 'Node.js', 1);

34
insert into tb_course_catalog values (default, 'AngularJS', 1);

35
insert into tb_course_catalog values (default, 'Bootstrap', 1);

36
insert into tb_course_catalog values (default, 'React', 1);

37
insert into tb_course_catalog values (default, 'Sass/Less', 1);

38
insert into tb_course_catalog values (default, 'Vue.js', 1);

39
insert into tb_course_catalog values (default, 'WebApp', 1);

40