The UPDATE statement is used to change the values in an existing record.
The UPDATE statement has this general format:
Format of SQL UPDATE statement |
Additional information |
---|---|
|
Here is an example of the use of the UPDATE statement:
Example of SQL UPDATE statement |
Additional information |
---|---|
|
This statement will start to populate (fill in with data) the Person table that we saw earlier in the chapter. The values are inserted into the record in the order in which the attributes are named.
18.227.111.197