Modifications to existing data are handled by the UPDATE statement. the UPDATE statement includes a WHERE clause in order to specify which rows should be targeted.
Syntax:
UPDATE table_name
SET column1 = value, column2 = value
WHERE some_column = some_value;
For exmple.
UPDATE customer
SET city = ‘Hamburg’
Where cust_name = ‘John’ AND Country = ‘Germany’
No comments:
Post a Comment