举一反三
- 智慧职教: delete from student where s_id > 5 该代码执行的是（）操作？
- delete from student where s_id > 5 的代码 如果取消 where s_id > 5 ，执行 delete from student 语句后的结果意味着什么?
- delete from student where s_id > 5 该代码执行的是哪项操作？
- DELETE FROM student WHERE s_id>5, 对该代码含义描述正确的是（） A: 删除student表中所有的s_id B: 删除student表中所有的s_id大于5的记录 C: 删除student表中所有的s_id大于等于5的记录 D: 删除student表
- 删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;
内容
- 0
delete from student where s_id > 5 该代码执行的是（） A: 添加记录 B: 修改记录 C: 删除记录 D: 查询记录
- 1
删除student表中id为1的记录（） A: TRUNCATE FROM student where id=1; B: DELETE student where id=1; C: DELETE FROM student where id=1; D: DELETE INTO student where id=1;
- 2
下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
- 3
Delete from studentwhere s_id > 5该代码所表示的实际操作为 A: 删除student表中所有s_id B: 删除student表中所有s_id 大于5的记录 C: 删除student表中所有s_id 大于等于5的记录 D: 删除student表
- 4
下面选项中,查询student表中id值不在2和5之间的学生,其中正确的SQL语句是() A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;