A: Update tbAddress Set strName="萌萌",intAge=22 Where ID=2
B: Update tbAddress Set strName=萌萌,intAge=22 Where strName=萌萌
C: Update tbAddress Set dtmSubmit=2008-10-1 Where strName="萌萌"
D: Update tbAddress Set intAge=18
举一反三
- 下面哪条语句可以查询姓“赵”并且年龄等于22岁的用户,请问用哪条语句?( ) A: Select * From tbAddress Where strName="赵" And intAge=22 B: Select * From tbAddress Where strName like "赵%" And intAge="22" C: Select * From tbAddress Where strName like "赵%" And intAge=22 D: Select * From tbAddress Where strName like "%赵%" And intAge=22
- 下面选项中,能够更新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';
- 把student表中id字段值小于3的记录,将这些记录的grade字段值都更新为100() A: UPDATE FROM student SET grade=100 where id<;3 B: UPDATE student SET grade=100 where id<;3 C: UPDATE student SET grade=100 D: UPDATE INTO student SET grade=100 where id<;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';
- 更新student表id=1的记录,name值更新为”youjun”,grade值更新为98.5,下列选项中,能够完成上述功能的SQL语句是 A: UPDATE student set name=’youjun’ grade=98.5 where id=1; B: UPDATE student set name=’youjun’, grade=98.5 where id=1; C: UPDATE FROM student set name=’youjun’ ,grade=98.5 where id=1; D: UPDATE student Values name=’youjun’ grade=98.5 where id=1;
内容
- 0
下面选项中,能够更新表student中id值小于4的SQL语句是() A: ALTER TABLE student where id<4; B: UPDATE student set grade=100 where id<4; C: UPDATE student set grade=100 where id<=4; D: UPDATE Table student set grade=100 where id<4;
- 1
假设表student中,有一条id=1的记录,现要求将其name修改为“huahua",grade修改为98.5.下列选项中,正确的SQL语句是( )。 A: UPDATE `student` SET `name`='huahua' `grade`=98.5 WHERE `id`=1 B: UPDATE `student` SET `name`='huahua', `grade`=98.5 WHERE `id`=1 C: UPDATE FOR `student` SET `name`='huahua', `grade`=98.5 WHERE `id`=1 D: UPDATE `student` `name`='huahua' `grade`=98.5 WHERE `id`=1
- 2
下面( )语句可以将选课表中不及格人的成绩提高10%。 A: UPDATE 选课 SET 成绩=成绩*10% WHERE 成绩<60 B: UPDATE 选课 SET 成绩=成绩+成绩*10% WHERE 成绩<60 C: UPDATE 选课 SET 成绩=成绩+成绩*0.1 WHERE 成绩<60 D: UPDATE 选课 SET 成绩=成绩*1.1 WHERE 成绩 IS ‘不及格’
- 3
下列MySQL命令中,可以实现更新记录的命令有()。 A: update 数据表参照关系 set 字段名称=值, [where 条件] [group by 字段名称] B: update 数据表,数据表, set 字段名称=值,where 条件 C: update 数据表 set 字段名称=值,[where 条件] D: update 数据表 set 字段名称=值, [where 条件] [order by 字段名称]
- 4
下面选项中,用于将表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;