„Update (SQL)“ – Versionsunterschied
| [ungesichtete Version] | [ungesichtete Version] |
Inhalt gelöscht Inhalt hinzugefügt
K Removed space before comma. I am a bot. Please revert my change if it was incorrect. I will notice automatically. |
|||
| Zeile 5: | Zeile 5: | ||
'''UPDATE''' ''table_name'' '''SET''' ''column_name'' = ''value'' ['''WHERE''' ''criteriavariable'' = ''value''] |
'''UPDATE''' ''table_name'' '''SET''' ''column_name'' = ''value'' ['''WHERE''' ''criteriavariable'' = ''value''] |
||
For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) over the table or column, the updated value must not conflict with all the applicable constraints (such as [[primary key]]s, unique indexes |
For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) over the table or column, the updated value must not conflict with all the applicable constraints (such as [[primary key]]s, unique indexes, CHECK constraints, and NOT NULL constraints). |
||
==Examples== |
==Examples== |
||
Version vom 7. März 2005, 14:09 Uhr
An UPDATE statement in SQL changes data in one or more records in a relational database management system.
UPDATE statement has the following form:
UPDATE table_name SET column_name = value [WHERE criteriavariable = value]
For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) over the table or column, the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes, CHECK constraints, and NOT NULL constraints).
Examples
UPDATE T SET C1 = 1 WHERE C2 = 'a'