从“课程基本情况表”表中将m08001号课去掉,正确的SQL语句是()。
A: DELETE FROM 课程基本情况表.课程号= m08001
B: DELETE FROM 课程基本情况表 WHERE m08001
C: DELETE FROM 课程基本情况表 WHERE 课程号='m08001'
D: DELETE FROM 课程基本情况表 IF 课程号= m08001
A: DELETE FROM 课程基本情况表.课程号= m08001
B: DELETE FROM 课程基本情况表 WHERE m08001
C: DELETE FROM 课程基本情况表 WHERE 课程号='m08001'
D: DELETE FROM 课程基本情况表 IF 课程号= m08001
举一反三
- 中国大学MOOC: 从“课程基本情况表”表中将m08001号课去掉,正确的SQL语句是()。
- 删除“课程基本情况”表中,课程名为“Java”的记录,正确的SQL语句是( )。 A: Delete From 课程基本情况 Where 课程名=“Java " B: Delete From 课程基本情况 Where 课程名= Java C: Delete 课程基本情况 Where 课程名=“Java " D: Delete 课程基本情况 Where 课程名= Java
- 删除“课程基本情况”表中,课程名为“Python”的记录,正确的SQL语句是( )。 A: Delete From 课程基本情况 Where 课程名=“Python B: Delete From 课程基本情况 Where 课程名=Python C: Delete 课程基本情况 Where 课程名=“Python D: Delete 课程基本情况 Where 课程名=Python
- 从“课程”表中将2003号课去掉,正确的SQL语句是()。 A: DELETE FROM课程.课号=2003 B: DELETE FROM课程 WHERE 2003 C: DELETE FROM课程 WHERE 课号=2003 D: DELETE FROM课程 IF 课号=2003
- 如下⼏个表所示学⽣、课程、必修课和选课关系,⽤SQL语⾔实现下列操作。 从“课程”表中将2003号课去掉,正确的SQL语句是( )。 A: DELETE FROM 课程 WHERE 课号=‘2003’; B: DELETE FROM 课程 WHERE 课号=2003; C: DELETE FROM 课程 WHERE ‘2003’; D: DELETE FROM 课程.课号=‘2003’;