下列选项中,能够一次性向student表中添加三条记录的SQL语句是
A: INSERT INTO student VALUES (6,'lilei',99);(7,'hanmeimei',100);(8,'poly',40.5);
B: INSERT INTO student VALUES (6,'lilei',99) (7,'hanmeimei',100) (8,'poly',40.5);
C: INSERT INTO student VALUES (6,'lilei',99),(7,'hanmeimei',100),(8,'poly',40.5);
D: INSERT INTO student VALUES (6,'lilei',99) VALUES(7,'hanmeimei',100) VALUES(8,'poly',40.5);
A: INSERT INTO student VALUES (6,'lilei',99);(7,'hanmeimei',100);(8,'poly',40.5);
B: INSERT INTO student VALUES (6,'lilei',99) (7,'hanmeimei',100) (8,'poly',40.5);
C: INSERT INTO student VALUES (6,'lilei',99),(7,'hanmeimei',100),(8,'poly',40.5);
D: INSERT INTO student VALUES (6,'lilei',99) VALUES(7,'hanmeimei',100) VALUES(8,'poly',40.5);
举一反三
- 下列选项中,能够一次给user表插入三条记录的SQL 语句是( )。 A: INSERT INTO user VALUES( 5,'张三');(6,'李四');(7, '王五'); B: INSERT INTO user VALUES( 5,'张三')(6,'李四')(7, '王五'); C: INSERT INTO user VALUES( 5,'张三'),(6,'李四'),(7, '王五'); D: INSERT INTO test VALUES( 5,'张三')VALUES(6,'李四')VALUES(7, '王五');
- 下列选项中，采用指定表的字段名的方式向表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,”小王”);
- 表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，“张三”)
- 向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)