下面哪个系统函数可以返回返回系统用户名?()
A: HOST_ID
B: HOST_NAME
C: SYSTEM_USER
D: CURRENT_USER
A: HOST_ID
B: HOST_NAME
C: SYSTEM_USER
D: CURRENT_USER
举一反三
- 获取当前登录服务器的主机地址及用户名使用（）函数。 A: USER() B: SYSTEM_USER() C: SESSION_USER() D: CURRENT_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';
- 下面通过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';
- 下面用来返回当前登录名的函数是() A: USER B: SHOW USER C: SESSION_USER D: SHOW USERS
- 【多选题】下面选项中, user表的用户列包括 A. Host列 B. User列 C. Password列 D. email列