孙向锦 / SunvoteEducation

常用操作数据库功能语句.txt 443 Bytes
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'