Statements (27)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:SQL_command
|
| gptkbp:affects |
one or more rows
|
| gptkbp:canBe |
gptkb:MySQL
gptkb:Oracle_Database gptkb:SQLite gptkb:PostgreSQL gptkb:SQL_Server transactions subqueries JOIN clause LIMIT clause (in some databases) RETURNING clause (in some databases) SET clause WHERE clause |
| gptkbp:canBeRolledBack |
if used within a transaction
|
| gptkbp:cause |
data modification
|
| gptkbp:hasSyntax |
UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
|
| gptkbp:partOf |
gptkb:Data_Manipulation_Language_(DML)
|
| gptkbp:purpose |
modifies existing records in a table
|
| gptkbp:relatedTo |
DELETE
INSERT SELECT |
| gptkbp:requires |
WHERE clause to specify which records to update
|
| gptkbp:usedIn |
SQL
|
| gptkbp:bfsParent |
gptkb:BGP
|
| gptkbp:bfsLayer |
5
|
| https://www.w3.org/2000/01/rdf-schema#label |
UPDATE
|