下面选项中,能够更新表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;
第1题
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;
第2题
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;
第3题
A.SELECT * FROM student where id!=2,3,4,5;
B.SELECT * FROM student where id not between 5 and 2;
C.SELECT * FROM student where id not between 2 and 5;
D.SELECT * FROM student where id not in 2,3,4,5;
第4题
A.DELETE student ,where id=11;
B.DELETE FROM student where id=11;
C.DELETE INTO student where id=11;
D.DELETE student where id=11;
第5题
A.SELECT * FROM student where id!=2,3,4,5;
B.SELECT * FROM student where id not between 5 and 2;
C.SELECT * FROM student where id not between 2 and 5;
D.SELECT * FROM student where id not in 2,3,4,5;
第6题
A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B.INSERT INTO Student(id,name) VALUES(1,’小王’)
C.INSERT INTO Student VALUES(1,”小王”)
D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)
第7题
A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B.INSERT INTO Student(id,name) VALUES(1,’小王’)
C.INSERT INTO Student VALUES(1,”小王”)
D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)
第8题
A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B.INSERT INTO Student(id,name) VALUES(1,’小王’)
C.INSERT INTO Student VALUES(1,”小王”)
D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)
第9题
A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B.INSERT INTO Student(id,name) VALUES(1,’小王’)
C.INSERT INTO Student VALUES(1,”小王”)
D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)
第10题
A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B.INSERT INTO Student(id,name) VALUES(1,’小王’)
C.INSERT INTO Student VALUES(1,”小王”)
D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)
第11题
A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B.INSERT INTO Student(id,name) VALUES(1,’小王’)
C.INSERT INTO Student VALUES(1,”小王”)
D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!