哪个能实现删除用户的命令( )。
A: delete from MySQL.user
B: delete user
C: drop root
D: truncate user
A: delete from MySQL.user
B: delete user
C: drop root
D: truncate user
A
举一反三
- 删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER
- 在 MySQL 中,删除用户的命令是( ) A: DROP USER B: REVOKE USER C: DELETE USER D: REMOVE USER
- 下面使用DELETE语句删除用户user2的语句中,正确的是 A: DELETE FROM mysql.user WHERE Host='localhost' AND User='user2'; B: DELETE FROM mysql.user WHILE Host='localhost' AND User='user2'; C: DELETE FROM mysql.user WHERE Host='localhost' OR User='user2'; D: DELETE FROM mysql.user WHILE Host='localhost' OR User='user2';
- 删除用户的同时删除用户所拥有的全部对象的正确命令是() A: drop user username cascade B: drop user username C: delete user username D: delete user username cascade
- hive中清空表user的HQL语句为( ) A: delete from user; B: remove table user; C: drop table user; D: truncate table user;
内容
- 0
下列SQL语句中能查看MySQL数据库用户帐号的是()。 A: SELECT user FROM mysql.user; B: SELECT USER();c、SELECT * FROM user;D、SELECT user FROM mysql;
- 1
删除用户账号lisi,且lisi账号存储在其他表中的权限也一并被删除,相对应的命令是( )。 A: drop user 'lisi'@'%'; B: drop 'lisi'@'%'; C: delete 'lisi'@'%'; D: delete from user where user='lisi' and host='%';
- 2
下列选项中,可以删除表user中所有记录的SQL语句是( )。 A: DELETE TABLE `user` B: DELETE FROM `user` C: DELETE `user` D: ALTER TABLE DELETE `user`
- 3
下面关于SQL语句“truncate table user”的描述,正确的是( )。 A: 清空user表中的所有数据 B: 与“delete from user”完全一样 C: 删除表中数据,但不影响自动增长值 D: 删除user表
- 4
以下SQL语句的功能是( )delete from user A: 删除user表第一条数据 B: 删除user表最后一条数据 C: 删除user表所有数据 D: 删除user表随机一条数据