Which statement is used for updating existing information in the table?
(a) UPDATE
(b) WHERE
(c) MODIFY
(d) ALTER
This question was addressed to me in a national level competition.
Asked question is from Populating & Modifying Tables in portion Using SQL to Manage Data of MySQL