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
举一反三
- 通过 SQL,您如何向 "Persons" 表插入新的记录? A: INSERT ('Jimmy', 'Jackson') INTO Persons B: INSERT VALUES ('Jimmy', 'Jackson') INTO Persons C: INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
- 通过 SQL,向 "Actor" 表插入新记录的正确表述是( )。? INSERT INTO Actor VALUES ('Jimmy', 'Jackson')|INSERT INTO Actor VALUE ('Jimmy', 'Jackson')|INSERT ('Jimmy', 'Jackson') INTO Actor|INSERT VALUES ('Jimmy', 'Jackson') INTO Actor
- 通过 SQL,您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ? A: INSERT INTO Persons (LastName) VALUES ('Wilson') B: INSERT ('Wilson') INTO Persons (LastName) C: INSERT INTO Persons ('Wilson') INTO LastName D: INSERT Persons (LastName) VALUES ('Wilson')
- 通过 SQL,您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ? A: INSERT INTO Persons (LastName) VALUES ('Wilson') B: INSERT ('Wilson') INTO Persons (LastName) C: INSERT INTO Persons ('Wilson') INTO LastName
- 如果使用下列语句创建TAB1 下列哪个语句会将记录成功插入表TAB1?() A: INSERT INTO tab1 VALUES (0, ’a’) B: INSERT INTO tab1 VALUES (NULL, ’abc’) C: INSERT INTO tab1 VALUES (4, ’a’) D: INSERT INTO tab1 VALUES (4, ’abcdefhijklmnopq’)
内容
- 0
通过 SQL,您如何从 "Persons" 表中选取所有的列? A: SELECT [all] FROM Persons B: SELECT Persons C: SELECT * FROM Persons D: SELECT *.Persons
- 1
通过 SQL,您如何返回 "Persons" 表中记录的数目? A: SELECT COLUMNS() FROM Persons B: SELECT COLUMNS(*) FROM Persons C: SELECT COUNT() FROM Persons D: SELECT COUNT(*) FROM Persons
- 2
下列哪些语句格式可以实现多行数据插入() A: insert into表名values (值列表) B: 表名insert into values(值列表) C: INSERT INTO表名select语句 D: Insert into表名(值列表)
- 3
智慧职教: 执行完下面的SQL语句,goods表中有几条记录?DROP TABLE IF EXISTS sCarInfo;CREATE TABLE sCarInfo(gdID INT ,uID INT,scNum INT,PRIMARY KEY(gdID,uID)) CHARSET utf8;INSERT INTO sCarInfo VALUES(1,1,2);INSERT INTO sCarInfo VALUES(1,1,3);INSERT INTO sCarInfo VALUES(2,1,2);INSERT INTO sCarInfo VALUES(1,2,2);INSERT INTO sCarInfo VALUES(1,null,2);INSERT INTO sCarInfo VALUES(null,1,2);
- 4
向“成绩”表末尾插入一条“学号”为“08102002”,“课程编号”为“4001”,“成绩”为“86”的新记录,正确的语句是()。 A: INSERT INTO成绩VALUES(08102002,4001,86) B: INSERT INTO成绩VALUES("08102002","4001",86) C: INSERT FOR成绩VALUES(08102002,4001,"86") D: INSERT FOR成绩VALUES("08102002","4001",86)