下面选项中,能够更新user表中数据的SQL语句是() A: update into user set id = 'u001'; B: update user set id = 'u001' and username='jack'; C: update user set username='jack' where id = 1; D: update into user set id = 'u001', username='jack';

下列用于更新的SQL语句中,正确的是() A: update<br/>user set id = u001 ; B: update<br/>user(id,username) values('u001','jack'); C: update<br/>user set id='u001',username='jack'; D: update<br/>into user set id = 'u001', username='jack';

解锁scott用户的正确命令是_______。 A: update user scott account unlock B: alert user scott account unlock C: update user scott unlock D: alert user scott unlock

【多选题】下列SQL语句在实际运行时,可能转换的SQL语句为() update user <set> <if test="uname!=null">uname=#{uname}, </if> <if test="usex!=null">usex=#{usex}</if> </set> where uid=#{uid} A. update user set uname=#{uname} where uid=#{uid} B. update user set uname=#{uname}, usex=#{usex} where uid=#{uid} C. update user usex=#{usex} where uid=#{uid} D. update user set uname=#{uname}, usex=#{usex}

下面选项中，用于将表user中字段age值更新为55的SQL语句是 A: ALTER TABLE user set age=55; B: UPDATE user set age=55 where age=55; C: UPDATE user set age=55; D: UPDATE user set age=55 where age&lt;=55;

“把查询SC表和更新SC表的grade列的权限授予用户user”的正确SQL语句是( )。 A: GRANT SELECT sc．UPDATE sc.grade TO user B: GRANT SELECT,UPDATE(grade)ON TABLE sc TO user C: GRANT SELECT,UPDATE ON TABLE sc．grade TO user D: GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc(grade)TO user

MYSQL中，可以使用_________语句来为指定数据库添加用户 A: set user B: create user C: update user D: drop user

下面通过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';

在MySQL数据库中，以下关于修改用户名称的语句正确是（）。 A: CREATE USER B: RENAME USER C: DROP USER D: UPDATE USER

以下创建用户账户正确的是（）。 A: insert user 用户名@可登录地址 identified by '密码'; B: create user 用户名@可登录地址 identified by '密码'; C: update user 用户名@可登录地址 identified by '密码'; D: set user 用户名@可登录地址 identified by '密码';