从“课程”表中将2003号课去掉,正确的SQL语句是()。
A: DELETE FROM课程.课号=2003
B: DELETE FROM课程 WHERE 2003
C: DELETE FROM课程 WHERE 课号=2003
D: DELETE FROM课程 IF 课号=2003
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’；
- 如下几个表所示学生、课程、必修课和选课关系，用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’；
- 如下几个表所示学生、课程、必修课和选课关系，用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;
- 如表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’
- 从“课程基本情况表”表中将m08001号课去掉，正确的SQL语句是（）。 A: DELETE FROM 课程基本情况表.课程号= m08001 B: DELETE FROM 课程基本情况表 WHERE m08001 C: DELETE FROM 课程基本情况表 WHERE 课程号='m08001' D: DELETE FROM 课程基本情况表 IF 课程号= m08001