要从tStudent表中删除记录，下列SQL-DELETE语句中哪个是正确的
A: DELETE tStudent
B: DELETE FROM tStudent
C: DELETE ALL tStudent
D: DELETE * FROM tStudent ALL
A: DELETE tStudent
B: DELETE FROM tStudent
C: DELETE ALL tStudent
D: DELETE * FROM tStudent ALL
举一反三
- 下列SQL-UPDATE语句用于修改tStudent表中的记录，哪个是正确的( ）。 A: UPDATE tStudent(出生日期) = #1998-1-2# WHERE 学号="20110101" B: UPDATE tStudent 出生日期=#1998-1-2# WHERE 学号="20110101" C: UPDATE tStudent SET 出生日期 = #1998-1-2# WHERE 学号="20110101" D: UPDATE tStudent SET 出生日期 = #1998-1-2# WHILE 学号="20110101"
- 下列SQL-UPDATE语句用于修改tStudent表中的记录,哪个是正确的()。 A: UPDATE tStudent SET 出生日期 = B: 1998-1-2 C: WHILE 学号="20110101" D: UPDATE tStudent 出生日期= E: 1998-1-2 F: WHERE 学号="20110101" G: UPDATE tStudent(出生日期) = H: 1998-1-2 I: WHERE 学号="20110101" J: UPDATE tStudent SET 出生日期 = K: 1998-1-2 L: WHERE 学号="20110101"
- 删除表course的记录。其SQL语句为（ ）。 A: DELETE from course where * B: DELETE * from course C: DELETE course D: DELETE FROM course
- 【单选题】删除 student 表的所有数据 A. delete * from student B. delete all from student C. delete from student D. delete rows from student
- 下列选项中，可以删除表user中所有记录的SQL语句是（ ）。 A: DELETE TABLE `user` B: DELETE FROM `user` C: DELETE `user` D: ALTER TABLE DELETE `user`