SQL UPDATE


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

SQL > SQL Basics > SQL UPDATE Statement


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

 
UPDATE <table_name>
SET <column_name> = <column_value>
WHERE <where_conditions>
 

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:

product_nbrproduct_name
1001 SQL Tool Light
1002 SQL Tool Professional
1003 SQL Tool Enterprise

 
UPDATE product
SET product_name = 'SQL Tool UltraLight'
WHERE product_nbr = '1001'
 

After executing the UPDATE the table contains:

product_nbrproduct_name
1001 SQL Tool Light
1002 SQL Tool Professional
1003 SQL Tool Enterprise

Copyright© 1999-2015, First Place Software, Inc.