【SQL开源代码栏目提醒】:本文主要为网学会员提供delete.sql,希望对需要delete.sql网友有所帮助,学习一下!
----删除不及格的选课信息
DELETE FROM stuCourse where stuMark < 60
----删除由丁春秋所教授的课程
----首先删除选择了丁春秋的
课程的选课信息
DELETE FROM stuCourse
WHERE stuCourse.courseID = course.ID AND course.tName = '丁春秋'
----这时再删除丁春秋的课程信息
DELETE FROM course where tName = '丁春秋'
----删除所有的学生选课信息
DELETE FROM stuCourse