下列选项中,采用指定表的所有字段名的方式向表Student中添加id为1,name为”小王”的记录值的SQL语句是()
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,”小王”)
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,”小王”)
第1题
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,”小王”)
第2题
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,”小王”)
第3题
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,”小王”)
第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;
第6题
第7题
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;
第8题
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;
第9题
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!