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}
update user set uname=#{uname}, usex=#{usex} where uid=#{uid}; update user usex=#{usex} where uid=#{uid}
举一反三
- 下面选项中,能够更新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';
- 下面选项中,用于将表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<=55;
- 下面通过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语句中,正确的是() 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';
- MYSQL中,可以使用_________语句来为指定数据库添加用户 A: set user B: create user C: update user D: drop user
内容
- 0
查看系统内核版本和当前用户的命令分别是? A: uname -a,whoami B: uname -a,top C: whoami,uname -a D: last,whoami
- 1
SQL修改数据语句关键字不包括( ) A: UPDATE B: FROM C: SET D: WHERE
- 2
智慧职教: 现在预编译语句对象为pstmt,如果为下列预编译SQL的第二个问号赋值为abc123,那么正确的选项是( )。 SELECT * FROM users where uname=? and pwd=?; 其中:uname是用户姓名,pwd是密码。
- 3
将所有计算机系学生的年龄增加1岁的正确语句是:( )。 A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS'; B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS'; C: UPDATE Student SET Sage =Sage + 1 WHERE Sdept = 'CS'; D: UPDATE Student SET Sage += 1 WHERE Sdept = 'CS';
- 4
现有用户信息表userinfo,表结构如下:id integer 主键,自增长;uname text 用户名;password text 密码。如果想添加用户名为张三,密码为123的用户,下面SQL语句正确的是() A: insert into userinfo(uname,password) values('张三','123'); B: insert into userinfo(uname,password) values(张三,123); C: insert into userinfo values(null,'张三','123'); D: insert into userinfo(password,uname) values('123','张三');