要删除数据表tb_user中的全部数据，下列（ ）方法不能实现。
A: DELETE FROM tb_user WHERE nme='ll';
B: DELETE FROM tb_user;
C: TRUNCTE TBLE tb_user;
D: DROP tb_user
A: DELETE FROM tb_user WHERE nme='ll';
B: DELETE FROM tb_user;
C: TRUNCTE TBLE tb_user;
D: DROP tb_user
举一反三
- 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;
- 要删除数据表tb_user中的全部数据，下列（ ）方法不能实现。 A: DELETE FROM tb_user WHERE name='all' B: DELETE FROM tb_user C: TRUNCATE TABLE tb_user
- 删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER
- 以下SQL语句的功能是( )delete from user A: 删除user表第一条数据 B: 删除user表最后一条数据 C: 删除user表所有数据 D: 删除user表随机一条数据
- 下列选项中，可以删除表user中所有记录的SQL语句是（ ）。 A: DELETE TABLE `user` B: DELETE FROM `user` C: DELETE `user` D: ALTER TABLE DELETE `user`