UPDATE "nombre_tabla"
SET "columna_1" = [nuevo valor]
WHERE {condición};
EJEMPLO:
UPDATE Store_Information
SET Sales = 500
WHERE store_name = "Los Angeles"
AND Date = "08-Jan-1999"
SET Sales = 500
WHERE store_name = "Los Angeles"
AND Date = "08-Jan-1999"
store_name | Sales | Date |
1500 € | 05-Jan-1999 | |
San Diego | 250 € | 07-Jan-1999 |
Los Angeles | 300 € | 08-Jan-1999 |
Boston | 700 € | 08-Jan-1999 |
El resultado seria:
Tabla Store_Information
store_name | Sales | Date |
Los Angeles | 1500 € | 05-Jan-1999 |
San Diego | 250 € | 07-Jan-1999 |
Los Angeles | 500 € | 08-Jan-1999 |
Boston | 700 € | 08-Jan-1999 |
