Statements (27)
Predicate | Object |
---|---|
gptkbp:instanceOf |
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;
|
https://www.w3.org/2000/01/rdf-schema#label |
UPDATE
|
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
|