UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];
Let's assume we are having a CUSTOMER
table as shown below:
ID | NAME | AGE | ADDRESS | SALARY |
---|---|---|---|---|
01 | Prayag | 21 | Ranchi | 35000 |
02 | Sujeet | 20 | Delhi | 25000 |
03 | Rakesh | 23 | Chennai | 225000 |
04 | Pankaj | 24 | Patna | 30000 |
The following query will update the ADDRESS for a customer whose ID number is 01 in the table.
SQL> UPDATE CUSTOMERS SET ADDRESS = 'Ranchi' WHERE ID = 01;
ID | NAME | AGE | ADDRESS | SALARY |
---|---|---|---|---|
01 | Prayag | 21 | Bangalore | 35000 |
02 | Sujeet | 20 | Delhi | 25000 |
03 | Rakesh | 23 | Chennai | 225000 |
04 | Pankaj | 24 | Patna | 30000 |
If you want to modify all the ADDRESS and the SALARY column values in the CUSTOMERS table, you do not need to use the WHERE
clause as the UPDATE
query would be enough as shown in the following code block.
SQL> UPDATE CUSTOMERS SET ADDRESS = 'Ranchi', SALARY = 1500;
ID | NAME | AGE | ADDRESS | SALARY |
---|---|---|---|---|
01 | Prayag | 21 | Ranchi | 1500 |
02 | Sujeet | 20 | Ranchi | 1500 |
03 | Rakesh | 23 | Ranchi | 1500 |
04 | Pankaj | 24 | Ranchi | 1500 |