孙向锦 / SunvoteEducation

Blame view

常用操作数据库功能语句.txt 443 Bytes
Edit Raw Normal View History
be2f84a1   孙向锦   添加课后作业基础模块数据 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
  删除老师和班级名下的测试数据：
  
  -- DELETE
  -- FROM
  -- 	sv_studenttest
  -- WHERE
  -- 	TEST_ID IN (
  -- 		SELECT
  -- 			TESTPAPER_ID
  -- 		FROM
  -- 			sv_testpaper
  -- 		WHERE
  -- 			TEACHER_ID = 'e38a18e965bc4d7ca937404a192bcb70'
  -- 		AND SCLASS_ID = '59d0e1f86bc34ff7920b8d58097e6864'
  -- 	)
  -- 
  delete FROM
  			sv_testpaper
  		WHERE
  			TEACHER_ID = 'e38a18e965bc4d7ca937404a192bcb70'
  		AND SCLASS_ID = '59d0e1f86bc34ff7920b8d58097e6864'