删除“课程”表中课程号为“J001”的课程信息的SQL语句是
A: DELETE FROM 课程 WHERE 课程号=J001
B: DELETE FROM 课程 WHERE 课程号=’J001’
C: SELECT * FROM 课程 WHERE 课程号=’J001’
D: DELETE * FROM 课程 WHERE 课程号=J001
A: DELETE FROM 课程 WHERE 课程号=J001
B: DELETE FROM 课程 WHERE 课程号=’J001’
C: SELECT * FROM 课程 WHERE 课程号=’J001’
D: DELETE * FROM 课程 WHERE 课程号=J001
举一反三
- 删除“课程”表中课程编号为“J001”的课程信息的SQL语句是( )。 A: DELETE FROM 课程 WHERE 课程编号=J001 B: DELETE FROM 课程 WHERE 课程编号=’J001’ C: SELECT * FROM 课程 WHERE 课程编号=’J001’ D: DELETE * FROM课程 WHERE 课程编号=J001
- 在“课程表”中删除课程编号为J001的记录，使用SQL命令( )。 A: INSERT FROM 课程表 WHERE 课程编号='J001' B: DELETE FROM 课程表 WHERE 课程编号='J001' C: UPDATE FROM 课程表 WHERE 课程编号='J001' D: SELECT FROM 课程表 WHERE 课程编号='J001'
- 从“课程基本情况表”表中将m08001号课去掉，正确的SQL语句是（）。 A: DELETE FROM 课程基本情况表.课程号= m08001 B: DELETE FROM 课程基本情况表 WHERE m08001 C: DELETE FROM 课程基本情况表 WHERE 课程号='m08001' D: DELETE FROM 课程基本情况表 IF 课程号= m08001
- 从“课程”表中将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’；