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

