SQL is a standard language for storing, manipulating, and retrieving data in databases.
The SQL UPDATE Statement
UPDATE statement is used to modify the existing records in a table.
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
SQL SET Keyword
The SET command is used with UPDATE to specify which columns and values should be updated in a table.
The following SQL updates the first category (CategoryID = 1) with a new Name and a new Type:
UPDATE Category SET Name = 'Article', Type = 'Premium' WHERE CategoryID = 1;