Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table? (Solved)
1. UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
2. MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
3. MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
4. UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
- d. UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’