往reader表中插入一个学生 ’2004060003’,’李亚茜’,3( )。
A: INSERT into ReaderVALUES('2004060003','李亚茜',3)
B: INSERT into Reader(RID,Rname,TypeID)VALUES('2004060003','李亚茜',3)
C: INSERT into Reader(RID,Rname,TypeID)VALUES('李亚茜','2004060003',3)
D: INSERT into Reader(RID,TypeID,Rname)VALUES('2004060003','李亚茜',3)
A: INSERT into ReaderVALUES('2004060003','李亚茜',3)
B: INSERT into Reader(RID,Rname,TypeID)VALUES('2004060003','李亚茜',3)
C: INSERT into Reader(RID,Rname,TypeID)VALUES('李亚茜','2004060003',3)
D: INSERT into Reader(RID,TypeID,Rname)VALUES('2004060003','李亚茜',3)
举一反三
- 下列( )可以实现从数据表tb_book中查询publishid和typeid字段的值,插入到数据表tb_book2中。 A: INSERT INTO tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book; B: INSERT FROM tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book; C: INSERT INTO FROM tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book; D: INSERT INTO tb_book(publishid,typeid) SELECT publishid, typeid FROM tb_book2;
- 假设某表有三个列:列名1、列名2、列名3,列1和列3非空,SQL插入语句写法正确的是: A: INSERT INTO 表名 (列名1,列名2,列名3)VALUES(值1,值2,值3); B: INSERT INTO 表名VALUES(值1,值2,值3); C: INSERT INTO 表名 (列名1,列名3)VALUES(值1,值3); D: INSERT INTO 表名 (列名1,列名2)VALUES(值1,值2);
- 有表students(sno,sname,xb,age,zhy,dept),除了age是int型,其他都是字符串类型,age字段可以为空。向students表插入数据的语句正确的是()。 A: INSERT students(sno,sname,xb,zhy,dept) VALUES ('201100010001','李明媚','女','软件技术','计算机技术'); B: INSERT students VALUES ('201100010001','李明媚','女',20,'软件技术'); C: INSERT students(sno,sname,xb,zhy,dept) VALUES ('201100010001','李明媚','女','软件技术'); D: INSERT students(sno,sname,age,zhy,dept) VALUES ('201100010001','李明媚','女','软件技术','计算机技术');
- 向职工表中插入一条记录的正确语句是()。 A: APPEND BLANK职工VALUES("33","3305","李运来","2700.00") B: APPEND INTO职工VALUES("33","3305","李运来",2700.00) C: INSERT INTO职工VALUES("33","3305","李运来","2700.00") D: INSER INTO职工VALUES("33","3305","李运来",2700.00)
- 通过SQL语句,如何往表“Persons”插入一条新纪录? A: INSERT ('Jimmy', 'Jackson') INTO Persons B: INSERT INTO Persons VALUES ('Jimmy', 'Jackson') C: INSERT VALUES ('Jimmy', 'Jackson') INTO Persons D: INSERT ('Jimmy', 'Jackson') INTO Persons Values