UPDATE

GPTKB entity

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