通过 SQL,向 "Actor" 表中的 "LastName" 列插入 "Wilson"表述正确的是()。
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)
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'