A: DELETE stu where stu_no=101
B: DELETE studnets
C: DELETE student WHERE stu_no=101
D: DELETE FROM student WHERE stu_no=101
举一反三
- $stu_no存放待删除学生的学号，请补充下面的代码？ $sql="delete from student where stu_no=_______";
- 以下删除stu表成绩小于60的记录，可是实现的代码是（） A: delete stu where score<60; B: delete from stu where score<60; C: delete stu D: truncate stu where score<60;
- 以下删除stu表成绩小于60的记录,可是实现的代码是() A: delete stu <br> where score<60; B: delete from stu <br> where score<60; C: delete stu D: truncate stu <br> where score<60;
- 下列关于删除表中记录的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;
- 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"
内容
- 0
删除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;
- 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语句中，用于删除student表中age小于20的记录的语句是 A: DELETE student where age<20; B: DELETE FROM student where age<20; C: DELETE FROM student set age<20; D: DELETE studentset age<20;
- 3
从student表删除年龄大于=30的记录的正确SQL命令是( )。 A: DELETE FOR年龄>30 B: DELETE FROM student WHERE年龄>30 C: DELETE student FOR年龄>30 D: DELETE student WHERE年龄>30
- 4
从student表删除年龄大于30的记录的正确SQL命令是 A: A) DELETE FOR 年龄＞30 B: B) DELETE FROM student WHERE 年龄＞30 C: C) DELETE student FOR 年龄＞30 D: D) DELETE student WHERE 年龄＞30