删除课程号为s5的课程记录，使用SQL语句：delete course cno="s5";
from# where
举一反三
- 用SQL语句逻辑删除xsqk表中记录号为5的记录,实现语句为() A: delete record5 B: delete next 5 C: delete fromxsqk whererecno()=5 D: deletefrom xsqkwhere record 5
- 删除表course的记录。其SQL语句为（ ）。 A: DELETE from course where * B: DELETE * from course C: DELETE course D: DELETE FROM course
- 删除“课程”表中课程号为“J001”的课程信息的SQL语句是 A: DELETE FROM 课程 WHERE 课程号=J001 B: DELETE FROM 课程 WHERE 课程号=’J001’ C: SELECT * FROM 课程 WHERE 课程号=’J001’ D: DELETE * FROM 课程 WHERE 课程号=J001
- 课程表的关系模式：course（cno,cname,credit,semester），将“网页设计与制作”课程的学分修改为：5，使用语句
- 删除“课程”表中课程编号为“J001”的课程信息的SQL语句是( )。 A: DELETE FROM 课程 WHERE 课程编号=J001 B: DELETE FROM 课程 WHERE 课程编号=’J001’ C: SELECT * FROM 课程 WHERE 课程编号=’J001’ D: DELETE * FROM课程 WHERE 课程编号=J001
内容
- 0
删除“课程基本情况”表中，课程名为“Java”的记录，正确的SQL语句是（ ）。 A: Delete From 课程基本情况 Where 课程名=“Java " B: Delete From 课程基本情况 Where 课程名= Java C: Delete 课程基本情况 Where 课程名=“Java " D: Delete 课程基本情况 Where 课程名= Java
- 1
删除“课程基本情况”表中，课程名为“Python”的记录，正确的SQL语句是（ ）。 A: Delete From 课程基本情况 Where 课程名=“Python B: Delete From 课程基本情况 Where 课程名=Python C: Delete 课程基本情况 Where 课程名=“Python D: Delete 课程基本情况 Where 课程名=Python
- 2
使用SQL语句将学生表S中年龄（AGE）大于30岁的记录删除，正确的命令是（） A: DELETE FOR AGE>30 B: DELETE FROM S WHERE AGE>30 C: DELETE S FOR AGE>30 D: DELETE S WHERE AGE>30
- 3
用SQL语句进行记录的删除操作，使用DELETE语句。()
- 4
若S5为8位标准逻辑位矢量，现有语句“S4<=S5(7 DOWNTO 5)”，则S4是（ ）位的标准逻辑位矢量。