The Update query is used to modify or update data in table.
Syntax:
|
1 2 3 |
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; |
example;
we have table cars with 3 rows as shown below:
lets update BMW color to yellow
|
1 2 3 |
update cars set color='yellow' where model='BMW' |
Output:
