„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:
'''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
==Examples==
| |||