Which SQL statement is used to update data in a table?
Show answerHide answer
Correct answer: (C) UPDATE
Explanation
UPDATE ... SET ... WHERE ... is the DML command that changes existing rows. SET is only a clause of UPDATE, and MODIFY is used with ALTER TABLE in some systems.