下面使用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: 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';
举一反三
- 下面通过UPDATE语句将root用户的密码修改为mypwd2的语句中,正确的是 A: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; B: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; C: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' OR Host='localhost'; D: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHILE User='root' OR Host='localhost';
- 下列SQL语句中能查看MySQL数据库用户帐号的是()。 A: SELECT user FROM mysql.user; B: SELECT USER();c、SELECT * FROM user;D、SELECT user FROM mysql;
- 哪个能实现删除用户的命令( )。 A: delete from MySQL.user B: delete user C: drop root D: truncate user
- 使用CREATE USER语句创建一个新用户,用户名为user2、密码为123 下面选项中,能实现上述功能的语句是 A: CREATE USER 'user2'@'localhost' IDENTIFIED BY '123'; B: CREATE USER user2@localhost IDENTIFIED BY 123; C: CREATE USER 'user2'@'localhost' IDENTIFIED TO '123'; D: CREATE USER user2@localhost IDENTIFIED TO '123';
- 删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER