将STUDENT、表中NL列的值都更新为20岁，正确的SQL语句是______
A: UPDATE STUDENT SET NL=21
B: SET STUDENT UPDATE NL=20
C: UPDATE STUDENT SET NL=20
D: INSERT INTO STUDENT SET NL=20
A: UPDATE STUDENT SET NL=21
B: SET STUDENT UPDATE NL=20
C: UPDATE STUDENT SET NL=20
D: INSERT INTO STUDENT SET NL=20
举一反三
- 下面选项中，用于将表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表中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 表中“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;
- 下面选项中，能够更新表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;
- 用SQL语句将STUDENT表中字段“年龄”的值加1，可以使用的命令是（ ）。 A: REPLACE STUDENT 年龄 = 年龄 +1 B: REPLACE STUDENT 年龄 WITH 年龄 +1 C: UPDATE STUDENT SET 年龄 = 年龄+1 D: UPDATE STUDENT SET 年龄 WITH 年龄+1