An UPDATE statement in SQL changes the data of one or more records in a table.
UPDATE tablename
SET column1 = expression1, column2 = expression2, ...
WHERE conditions;
Example 1:
UPDATE country SET countryname='Spain' WHERE countrycode=34;
Example 2:
UPDATE country SET countryname=NULL WHERE countrycode=34;