如表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’
A: DELETE FROM 课程 WHERE 课号=‘2003’
B: DELETE FROM 课程 WHERE 课号=2003
C: DELETE FROM 课程 WHERE ‘2003’
D: DELETE FROM 课程.课号=‘2003’
举一反三
- 从“课程”表中将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’；
- 如下几个表所示学生、课程、必修课和选课关系，用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;
- 如下几个表所示学生、课程、必修课和选课关系，用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’；