下列选项中,可以删除表user中所有记录的SQL语句是( )。
A: DELETE TABLE `user`
B: DELETE FROM `user`
C: DELETE `user`
D: ALTER TABLE DELETE `user`
A: DELETE TABLE `user`
B: DELETE FROM `user`
C: DELETE `user`
D: ALTER TABLE DELETE `user`
举一反三
- 删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER
- hive中清空表user的HQL语句为( ) A: delete from user; B: remove table user; C: drop table user; D: truncate table user;
- 【单选题】如何删除students表中的所有记录() A. Drop table students; B. Delete from students; C. Alter table students; D. delete user students;
- 下面关于SQL语句“truncate table user”的描述,正确的是( )。 A: 清空user表中的所有数据 B: 与“delete from user”完全一样 C: 删除表中数据,但不影响自动增长值 D: 删除user表
- 以下SQL语句的功能是( )delete from user A: 删除user表第一条数据 B: 删除user表最后一条数据 C: 删除user表所有数据 D: 删除user表随机一条数据