PYTHON第六十六天笔记11.27

 

二、MYSQL数据结构创建

建表结构：
        
            - 班级表：
                create table class(
                    id int auto_increment primary key,
                    name char(10) not null
                )engine=innodb default charset="utf8";
        
            - 老师表：
             create table teacher(
                 id int auto_increment primary key,
                 name char(10) not null
            )engine=innodb default charset="utf8";
            
            - 学生表：
                 create table student(
                     id int auto_increment primary key,
                     name char(10) not null,
                     class_id int, foreign key(class_id) references class(id) on delete cascade on update cascade
                 )engine=innodb default charset="utf8";
            
            - teacher2class
                 create table teacher2class(
                     id int auto_increment primary key,
                     class_id int, foreign key(class_id) references class(id) on delete cascade on update cascade,
                     teacher_id int, foreign key(teacher_id) references teacher(id) on delete cascade on update cascade
                 )engine=innodb default charset="utf8";

 

三、课堂图片

1 pycharm项目启动改端口

2

3

4

5 return render(request,'index.html')

6 return redirect('/index.html/')

7

8

9

10 助教画流程图