The UPDATE Query in SQL is used to modify and change the existing values in the columns. The WHERE clause is used with the UPDATE Statement which has a condition to update the selected columns. The WHERE clause determines which records will be updated.
- Syntax of UPDATE statement –
UPDATE table_name
SET column1 = value1, column1 = value1 ,..., columnN = valueN
WHERE condition;
The SQL UPDATE query cannot be rolled back. When we execute the query, it will change all the values as per the condition in the WHERE clause. It is asked to be careful while doing so.
Demo Table –
Product Table
| Category | Region | City | Country | Customer_ID | Customer_name |
| Office Supplies | Central | Chicago | United States | SM-20950 | Suzanne McNair |
| Technology | East | New York City | United States | AH-10465 | Amy Hunt |
| Office Supplies | East | New York City | United States | AH-10465 | Amy Hunt |
| Office Supplies | East | Dover | United States | EP-13915 | Emily Phan |
| Office Supplies | East | Dover | United States | EP-13915 | Emily Phan |
| Technology | West | Aurora | United States | TP-21565 | Tracy Poddar |
| Office Supplies | West | Aurora | United States | TP-21565 | Tracy Poddar |
| Office Supplies | East | Long Beach | United States | AR-10825 | Anthony Rawles |
| Office Supplies | West | Pasadena | United States | HA-14920 | Helen Andreada |
| Furniture | West | Pasadena | United States | HA-14920 | Helen Andreada |
Example – Consider the Product table of the Customer database, and update the Country name from the United States to the U.S where the category is Office supplies.
UPDATE [dbo].[Products]
SET [Country/Region] = 'U.S' WHERE Category = 'Office Supplies';
This output is the small section of the output by executing the above query –
| Category | Region | City | Country | Customer_ID | Customer_name |
| Office Supplies | Central | Chicago | U.S | SM-20950 | Suzanne McNair |
| Technology | East | New York City | United States | AH-10465 | Amy Hunt |
| Office Supplies | East | New York City | U.S | AH-10465 | Amy Hunt |
| Office Supplies | East | Dover | U.S | EP-13915 | Emily Phan |
| Office Supplies | East | Dover | U.S | EP-13915 | Emily Phan |
| Technology | West | Aurora | United States | TP-21565 | Tracy Poddar |
| Office Supplies | West | Aurora | U.S | TP-21565 | Tracy Poddar |
| Office Supplies | East | Long Beach | U.S | AR-10825 | Anthony Rawles |
| Office Supplies | West | Pasadena | U.S | HA-14920 | Helen Andreada |
| Furniture | West | Pasadena | United States | HA-14920 | Helen Andreada |
In the output, the Country name is changed to the U.S from the United States wherever we have the category as Office supplies.
Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.
If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.
#analytics #data #business #artificialintelligence #machinelearning #startup #deeplearning #deeplearning #datascience #ai #growth #dataanalytics #india #datascientist #powerbi #dataanalysis #tableau #SQL #businessanalytics #businessanalyst #businessandmanagement #dataanalyst #businessanalysis #analyst #analysis #powerbideveloper #powerbidesktop #letsviz
