GITTA-Logo
PDF Version of this document Search Help

Lesson Navigation IconAnfragesprache SQL

Unit Navigation IconSQL Overview

Unit Navigation IconBasic database queries

Unit Navigation IconSQL Insert, Delete and Update

LO Navigation IconInserting tuples

LO Navigation IconDeleting tuples

LO Navigation IconUpdating tuples

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Updating tuples

The update-command is used to change one or more attribute values of existing tuples. The WHERE-clause specifies which tuples should be updated. The SET-clause specifies the new values.

The syntax is:

UPDATE Tablename
SET Attributevalues
WHERE Condition;

Updating tuples
Top Go to previous page Go to next page