How to use UPDATE statement in SQL

Editor to share with you how to use the UPDATE sentence in SQL. I hope you will get something after reading this article. Let's discuss it together.

SQL UPDATE statement

The Update statement is used to modify the data in the table. The syntax is as follows:

UPDATE table name SET column name = new value WHERE column name = a value

"Person" table:

LastName FirstName Address CityGates Bill Xuanwumen 10 BeijingWilson Champs-Elysees

Update a column in a row

UPDATE Person SET FirstName = "Fred" WHERE LastName = "Wilson"

Results:

LastName FirstName Address CityGates Bill Xuanwumen 10 BeijingWilson Fred Champs-Elysees

Note: this example adds firstname for people whose lastname is "Wilson".

Update several columns in a row

UPDATE Person SET Address = "Zhongshan 23", City = "Nanjing" WHERE LastName = "Wilson"

Results:

LastName FirstName Address CityGates Bill Xuanwumen 10 BeijingWilson Fred Zhongshan 23 Nanjing

Note: this example modifies the address (address) and adds the city name (city).

After reading this article, I believe you have some understanding of "how to use UPDATE sentences in SQL". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!