What is the SQL UPDATE Statement?
The SQL UPDATE statement is the SQL command that makes changes to data that exists in a SQL database.
Why Use the SQL UPDATE Statement?
Anytime you want to change information in a SQL database use the SQL UPDATE statement to cause the change.
How To Use the SQL UPDATE Statement
The SQL Update command is used as follows.
SQL UPDATE Statement Syntax
SQL UPDATE Statement Example 1
The following example updates the product_name to 'SQL Tool UltraLight' where product_nbr equals '1001'.
Before executing the UPDATE the table contains:
After executing the UPDATE the table contains: