10. Modify

We already know how to query, filter, order, add new data and delete. The only thing left is to change existing data. The reserved word for this task is UPDATE.

UPDATE [tabla] SET [columna] = [nuevo valor], [columna] = [nuevo valor], ... WHERE [condicion];

Let's change the customer with Id 10, named Eduardo, to indicate that he is now at a small company called Facebook.

UPDATE Customer SET Company = 'Facebook' WHERE CustomerId = 10;

Did he move to Valencia? We change the columns that are needed.

UPDATE Customer SET City = 'Valencia', State = 'Comunidad Valenciana', Country = 'Spain' WHERE CustomerId = 10;

Our boss wants to change all the countries that say USA to EEUU.

UPDATE Customer SET Country = 'EEUU' WHERE Country = 'USA';

Solutions