A: INSERT INTO Actor (LastName) VALUES ('Wilson')
B: INSERT INTO Actor ('Wilson') INTO LastName
C: INSERT INTO Actor ('Wilson') INTO (LastName)
D: INSERT ('Wilson') INTO Actor (LastName)
举一反三
- 通过 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
- 通过 SQL,将'Actor' 表中 'LastName' 列的 'Gates' 改为 'Wilson' 正确的是( )。
- 通过SQL,将"Actor"表中"LastName"列的"Gates"改为"Wilson"正确的是()。 A: UPDATEActorSETLastName='Wilson'WHERELastName='Gates' B: UPDATEActorSETLastName='Wilson'INTOLastName='Gates' C: MODIFYActorSETLastName='Wilson'WHERELastName='Gates' D: MODIFYActorSETLastName='Wilson'INTOLastName='Gates'
- 您如何把 "Persons" 表中 "LastName" 列的 "Gates" 改为 "Wilson" ? A: MODIFY Persons SET LastName='Wilson' WHERE LastName='Gates' B: UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates' C: UPDATE Persons SET LastName='Wilson' INTO LastName='Gates' D: MODIFY Persons SET LastName='Wilson' INTO LastName='Gates'
内容
- 0
通过 SQL,按字母顺序选取 Actor 表中 LastName 介于 Adams 和 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE LastName BETWEEN 'Adams' AND 'Carter' B: SELECT * FROM Actor WHERE LastName>'Adams' AND LastName<'Carter' C: SELECT LastName>'Adams' AND LastName<'Carter' FROM Actor D: SELECT * FROM Actor WHERE LastName>'Adams' OR LastName<'Carter'
- 1
通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。? SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter'|SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'|SELECT FirstName='Jim', LastName='Carter' FROM Actor|SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter'
- 2
通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'
- 3
通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'
- 4
通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'