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
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 |
After executing the UPDATE the table contains:
product_nbr | product_name |
1001 | SQL Tool Light |
1002 | SQL Tool Professional |
1003 | SQL Tool Enterprise |
Advertisements:
Infogoal.com is organized to help you gain mastery.
Examples may be simplified to facilitate learning.
Content is reviewed for errors but is not warranted to be 100% correct.
In order to use this site, you must read and agree to the
terms of use, privacy policy and cookie policy.
Copyright 2006-2020 by Infogoal, LLC. All Rights Reserved.