【单选题】删除 student 表的所有数据
A. delete * from student B. delete all from student C. delete from student D. delete rows from student
A. delete * from student B. delete all from student C. delete from student D. delete rows from student
举一反三
- 删除学生信息表student的所有数据，正确的语句为（ ）。 A: delete from student B: drop all from student C: delete all * from student D: drop table student
- 删除student表所有的记录，下列语句正确的是 A: DELETE FROM TABLE student; B: DELETE TABLE student; C: TRUNCATE TABLE student; D: TRUNCATE FROM TABLE student;
- 学生表student中，将年龄小于30岁的记录删除，下面的语句正确的是（ ）。 A: DELETE FROM student FOR age<;30 B: DELETE FROM student WHERE age<;30 C: DELETE TABLE student WHERE age<;30 D: DELETE FROM student HAVING age<;30
- 删除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中的数据，应该使用（）。 A: Drop Table Student B: Delete from Student C: Delete table D: Drop Student