The Writing of sql Modification statement

Editor to share with you how to write sql modified sentences. I hope you will gain a lot after reading this article. Let's discuss it together.

The sql modification statement is written as follows: [UPDATE table name SET column name = new value WHERE column name = some value]. The update statement is used to modify the data in the data table.

The Update statement is used to modify the data in the table.

Syntax:

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

For example:

The Person table is as follows:

Now let's update a column in a row. We add firstname for people whose lastname is "Wilson":

Sql statement:

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

The changed table is as follows:

After reading this article, I believe you have a certain understanding of the writing of sql modified sentences, want to know more about it, welcome to follow the industry information channel, thank you for reading!