下面选项中，能够更新表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;
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;
举一反三
- 把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
- 更新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;
- 假设表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
- 下面选项中，用于将表student中字段grade值更新为80的SQL语句是( ) A: ALTER TABLE student set grade=80; B: UPDATE student set grade=80 where grade=80; C: UPDATE student set grade=80 where grade<=80; D: UPDATE student set grade=80;
- 下列选项中,用于将student 表中“grade " 字段的值修改为“80”的SQL 语句是( )。 A: ALTER TABLE student set grade=80; B: ALTER student set grade=80; C: UPDATE student set grade=80 where grade<;80; D: UPDATE student set grade=80;