The following SQL command is run:
UPDATE people SET LastName=”Albert”;What is the problem with this statement?
- Since there is no WHERE clause, it sets the last name of all the people in table
- Syntax is incorrect, resulting in an error message
- Data type has to be specified for LastName
- Table name people should be capitalized
Please login or Register to submit your answer