向信息系学生视图IS_STUDENT中插入一个新的学生记录,其中,学号0002,姓名为王二小,年龄为16岁,正确的SQL语句是( )。
A: INSERT INTO IS_STUDENT
B: VALUES('0002','王二小',16)
C: INSERT INTO IS_STUDENT
D: VALUES(0002,'王二小',16)
E: SELECT INTO IS_STUDENT
F: VALUES(0002,王二小,16)
G: SELECT INTO IS_STUDENT
H: VALUES('0002','王二小',16)
A: INSERT INTO IS_STUDENT
B: VALUES('0002','王二小',16)
C: INSERT INTO IS_STUDENT
D: VALUES(0002,'王二小',16)
E: SELECT INTO IS_STUDENT
F: VALUES(0002,王二小,16)
G: SELECT INTO IS_STUDENT
H: VALUES('0002','王二小',16)
举一反三
- 建立信息系统学生的视图是() A: CREATE VIEW is_student AS SELECT sno,sname,sage FROM student WHERE sdpt='is'; B: CREATE VIEW is_student SELECT sno,sname,sageFROM WHERE sdpt='is'; C: CREATE VIEW is_student AS select sno,sname,sage FROM WHERE sdpt='is' D: CREATE VIEW is_student AS SELECT sno,sname,sage WHERE sdpt='is';
- 在MySQL中,设有学生表Student(sno,sname,sage),各字段的含义分别是学生学号、姓名、年龄。下列语句会报错是________。 A: insert into Student(sno,sname,sage) values('201530','Jakc',18) B: insert into Student(sno,sname) values('201530','Jakc') C: insert into Student values('201530','Jakc') D: insert into Student values('201530','Jakc',18)
- 向student表插入一条新记录的正确SQL语句是( )。 A: APPEND INTO student VALUES(′0401′,′王芳’,′女′,18) B: APPEND student VALUES(′0401′,′王芳′,′女′,18) C: INSERT INTO student VALUES(′0401′,′王芳′,′女′,18) D: INSERT student VALUES(′0401′,′王芳′,′女′,18)
- 向student表插入一条新记录的正确SQL语句是______。 A: INSERT INTO student VALUES("0401","丽萍","女",18) B: APPEND student VALUES("0401","丽萍","女",18) C: APPEND INTO student VALUES("0401","丽萍","女",18) D: INSERT student VALUES("0401","丽萍","女",18)
- 表student中的包含两个字段,整型的id,字符串型的name。向表student中插入一条记录的正确SQL语句( ) A: insert into student(2018001,“张三”) B: insert into student values(2018001,'张三') C: insert into student(2018001,'张三') D: insert into student values (2018001,“张三”)