SQL UPDATE Statement

SQL > SQL Basics > SQL UPDATE Statement

The SQL UPDATE statement is the SQL command that makes changes to data that exists in a SQL database.

Anytime you want to change information in a SQL database use the SQL UPDATE statement to cause the change.

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_nbr product_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_nbr product_name

1001 SQL Tool Light

1002 SQL Tool Professional

1003 SQL Tool Enterprise