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 ]