you are at Encyclopedia of SQL >> UPDATE
UPDATE
With UPDATE we can change or update value in column in table
Syntax
UPDATE `table_name`
SET `column_name`='value'
[WHERE `column_name` operator 'value']
Not specifing condition after WHERE causes modification of all columns
Example
Change Jan Kowalski's age on 30
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
| Jan | Kowalski | NULL |
query
UPDATE `people`
SET `age`=30
WHERE `name`='Jan' AND `surname`='Kowalski'
result
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
| Jan | Kowalski | 30 |
[ wróć na górę strony ]
