DRF 的SQL 语句

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);```

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值