Delete from studentwhere s_id > 5该代码所表示的实际操作为
A: 删除student表中所有s_id
B: 删除student表中所有s_id 大于5的记录
C: 删除student表中所有s_id 大于等于5的记录
D: 删除student表
A: 删除student表中所有s_id
B: 删除student表中所有s_id 大于5的记录
C: 删除student表中所有s_id 大于等于5的记录
D: 删除student表
举一反三
- DELETE FROM student WHERE s_id>5, 对该代码含义描述正确的是（） A: 删除student表中所有的s_id B: 删除student表中所有的s_id大于5的记录 C: 删除student表中所有的s_id大于等于5的记录 D: 删除student表
- delete from student where s_id > 5 该代码执行的是（） A: 添加记录 B: 修改记录 C: 删除记录 D: 查询记录
- 删除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;
- 删除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;
- delete from student where s_id > 5 的代码 如果取消 where s_id > 5 ，执行 delete from student 语句后的结果意味着什么?