下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是()。
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;
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;
第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.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;
第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.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,”小王”)
第5题
A.查询user表中的所有数据
B.与“delete from user;“完全一样
C.不仅清空user表中的所有数据,并可以重置auto_increment的值。
D.删除user表
第6题
A.删除user表
B.不仅清空user表中的所有数据,并可以重置auto_increment的值。
C.与“delete from user;“完全一样
D.查询user表中的所有数据
第7题
A.String sql="Select * from Student where Sname="+txtName.getText();
B.String sql="Select * from Student where Sname='"+txtName.getText()+"'";
C.String sql="Select * from Student where Sname like "+txtName.getText();
D.String sql="Select * from Student where Sname like '"+txtName.getText()+"'";
第8题
A.String sql="Select * from Student where Sname="+txtName.getText();
B.String sql="Select * from Student where Sname='"+txtName.getText()+"'";
C.String sql="Select * from Student where Sname like "+txtName.getText();
D.String sql="Select * from Student where Sname like '"+txtName.getText()+"'";
第9题
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!