INSERT INTO students.sch_teacher ( id, NAME, sex )
VALUES
( 1, '李老师', 8 );
INSERT INTO students.sch_teacher ( id, NAME, sex )
VALUES
( 2, '曹老师', 1 );
INSERT INTO students.sch_teacher ( id, NAME, sex )
VALUES
( 3, '许老师', 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 1, '小明', 18, 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 2, '小黑', 22, 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 3, '小白', 18, 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 4, '小红', 17, 8 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 5, '小程', 18, 8 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 6, '小辉', 16, 0 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 7, '小明2', 18, 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 8, '小黑2', 22, 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 9, '小自2', 18, 1 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 10, '小红2', 17, 0 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 11, '小程2', 18, 0 );
INSERT INTO students.sch_student ( id, NAME, age, sex )
VALUES
( 12, '小辉2', 16, 8 );
INSERT INTO students.sch_course ( id, NAME, teacher_id )
VALUES
( 1, 'python入门', 1 );
INSERT INTO students.sch_course ( id, NAME, teacher_id )
VALUES
( 2, 'python进阶', 2 );
INSERT INTO students.sch_course ( id, NAME, teacher_id )
VALUES
( 3, 'python高级', 3 );
INSERT INTO students.sch_course ( id, NAME, teacher_id )
VALUES
( 4, 'django入门', 2 );
INSERT INTO students.sch_course ( id, NAME, teacher_id )
VALUES
( 5, 'django进阶', 3 );
INSERT INTO students.sch_course ( id, NAME, teacher_id )
VALUES
( 6, 'django高级', 3 );
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25',1,100.0,1,1);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000' ,2,100.0,2,2);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',3,100.0,3,3);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',4,78.0,4,4);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',5,78.0,5,5);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000' ,6,78.0,6,6);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',7,78.0,1,7);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',8,80.0,2,8);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',9,80.0,3,9);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',10,80.0,4,10);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',11,80.0,5,11);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000' ,12,60.0,6,12);
INSERT INTO students.school_achievement(create_dtime,id,score,course_id,student_id) VALUES ( '2021-06-16 01:18:25.496000',13,100.0,1,2);
INSERT INTO students.school_achievement(create_dtime,id,score,course_id,student_id) VALUES ( '2021-06-16 01:18:25.496000',14,100.0,2,3);
INSERT INTO students.school_achievement(create_dtime,id,score,course_id,student_id) VALUES ( '2021-06-16 01:18:25.496000',15,100.0,3,4);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ( '2021-06-16 01:18:25.496000',16,78.0,4,5);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ( '2021-06-16 01:18:25.496000',17,78.0,5,6);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',18,78.0,6,7);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id) VALUES ('2021-06-16 01:18:25.496000',19,78.0,1,8);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id)VALUES ( '2021-06-16 01:18:25.496000',20,78.0,2,9);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id)VALUES ('2021-06-16 01:18:25.496000',21,80.0,3,10);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id)VALUES ('2021-06-16 01:18:25.496000',22,80.0,4,11);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id)VALUES ('2021-06-16 01:18:25.496000',23,80.0,5,12);
INSERT INTO students.school_achievement (create_dtime,id,score,course_id,student_id)VALUES ('2021-06-16 01:18:25.496000',24,60.0,6,1);```
DRF 的SQL 语句
最新推荐文章于 2023-02-08 15:19:33 发布