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’；
内容
- 0
如表10.3、表10.4、表10.5和表10.6所示，用SQL语言实现下列操作。 [img=520x266]1803a8f3d46e53c.png[/img]从“课程”表中将2003号课去掉，正确的SQL语句是_____ 。 A: DELETE FROM 课程 WHERE 课号=‘2003’ B: DELETE FROM 课程 WHERE 课号=2003 C: DELETE FROM 课程 WHERE ‘2003’ D: DELETE FROM 课程.课号=‘2003’
- 1
删除“课程”表中课程号为“J001”的课程信息的SQL语句是 A: DELETE FROM 课程 WHERE 课程号=J001 B: DELETE FROM 课程 WHERE 课程号=’J001’ C: SELECT * FROM 课程 WHERE 课程号=’J001’ D: DELETE * FROM 课程 WHERE 课程号=J001
- 2
如下几个表所示学生、课程、必修课和选课关系，用SQL语言实现下列操作。[img=811x422]180351b6160e8c2.png[/img]从“课程”表中将2003号课去掉，正确的SQL语句是_____。 A: DELETE FROM 课程 WHERE 课号=‘2003’； B: DELETE FROM 课程 WHERE 课号=2003； C: DELETE FROM 课程 WHERE ‘2003’； D: DELETE FROM 课程.课号=‘2003’；
- 3
如下几个表所示学生、课程、必修课和选课关系，用SQL语言实现下列操作。[img=811x422]1803469365c412f.png[/img]从“课程”表中将2003号课去掉，正确的SQL语句是（）。 A: DELETE FROM 课程 WHERE '2003'; B: DELETE FROM 课程.课号='2003'; C: DELETE FROM 课程 WHERE 课号='2003'; D: DELETE FROM 课程 WHERE 课号=2003;
- 4
如下几个表所示学生、课程、必修课和选课关系，用SQL语言实现下列操作。 从“课程”表中将2006号课去掉，正确的SQL语句是_____。[img=520x271]1803469213d24d8.png[/img] A: DELETE FROM 课程 WHERE 课号=2006； B: DELETE FROM 课程 WHERE 课号=‘2006’； C: DELETE FROM 课程 WHERE ‘2006’； D: DELETE FROM 课程.课号=‘2006’；