UPDATE
<Back to Last Page> <Full Glossary>
Definition:
The UPDATE statement in SQL
is used to edit values for attributes in one
or more records of a relational table.
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.
<
Back to Last Page> <
Full Glossary>
