6.要删除数据表tb_user中的全部数据,下列()方法不能实现。
A: DELETE FROM tb_user WHERE name='all';
B: DELETE FROM tb_user;
C: TRUNCATE TABLE tb_user;
D: DROP TABLE tb_user;
A: DELETE FROM tb_user WHERE name='all';
B: DELETE FROM tb_user;
C: TRUNCATE TABLE tb_user;
D: DROP TABLE tb_user;
举一反三
- 要删除数据表tb_user中的全部数据，下列（ ）方法不能实现。 A: DELETE FROM tb_user WHERE name='all' B: DELETE FROM tb_user C: TRUNCATE TABLE tb_user
- 要删除数据表tb_user中的全部数据，下列（ ）方法不能实现。 A: DELETE FROM tb_user WHERE nme='ll'; B: DELETE FROM tb_user; C: TRUNCTE TBLE tb_user; D: DROP tb_user
- hive中清空表user的HQL语句为（ ） A: delete from user; B: remove table user; C: drop table user; D: truncate table user;
- 删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER
- 下列选项中，可以删除表user中所有记录的SQL语句是（ ）。 A: DELETE TABLE `user` B: DELETE FROM `user` C: DELETE `user` D: ALTER TABLE DELETE `user`