DELETE FROM student WHERE 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 studentwhere s_id > 5该代码所表示的实际操作为 A: 删除student表中所有s_id B: 删除student表中所有s_id 大于5的记录 C: 删除student表中所有s_id 大于等于5的记录 D: 删除student表
- 删除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;
- 下列关于删除表中记录的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;
- delete from student where s_id > 5 该代码执行的是（） A: 添加记录 B: 修改记录 C: 删除记录 D: 查询记录