|
Example: Given the following table:
Members
| ID | Last Name | Age |
| 1 | Smith | 25 |
| 2 | Jones | 42 |
| 3 | Reynolds | 36 |
Assume that the member Jones recently changed her last name to McGuire. This change could be effected using the following SQL statement:
UPDATE Members
SET LastName = 'McGuire'
WHERE ID = 2
Related Resources:
Structured Query Language
Visit our Structured Query Language subject page for more on this topic.
Elsewhere on the Web:
Getting Started with SQL
The Web Developer's Virtual Library provides a very readable introduction to the Structured Query Language.
