UPDATE COMMAND IN SQL - sql - sql tutorial - learn sql
- The UPDATE statement is used to modify the existing records in a table.
- In the Update statement, WHERE clause identifies the rows that get affected.
- If you do not include the WHERE clause, column values for all the rows get affected.
Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorialSyntax
Syntax
- The basic syntax of the UPDATE query with a WHERE clause is as follows
- You can combine N number of conditions using the AND or the OR operators.
sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorialExample
Example
- Consider the WIKITECHY_CUSTOMERS table having the following records −
ID | NAME | AGE | ADDRESS | SALARY |
---|---|---|---|---|
1 | Ramesh | 32 | Ahmedabad | 2000.00 |
2 | Khilan | 25 | Delhi | 1500.00 |
3 | kaushik | 23 | Kota | 2000.00 |
4 | Chaitali | 25 | Mumbai | 6500.00 |
5 | Hardik | 27 | Bhopal | 8500.00 |
6 | Komal | 22 | MP | 4500.00 |
7 | Muffy | 24 | Indore | 10000.00 |
- The following query will update the ADDRESS for a customer whose ID number is 6 in the table.
- Now, the WIKITECHY_CUSTOMERS table would have the following records −
ID | NAME | AGE | ADDRESS | SALARY |
---|---|---|---|---|
1 | Ramesh | 32 | Ahmedabad | 2000.00 |
2 | Khilan | 25 | Delhi | 1500.00 |
3 | kaushik | 23 | Kota | 2000.00 |
4 | Chaitali | 25 | Mumbai | 6500.00 |
5 | Hardik | 27 | Bhopal | 8500.00 |
6 | Komal | 22 | Pune | 4500.00 |
7 | Muffy | 24 | Indore | 10000.00 |
- If you want to modify all the ADDRESS and the SALARY column values in the WIKITECHY_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.
- Now, WIKITECHY_CUSTOMERS table would have the following records −
ID | NAME | AGE | ADDRESS | SALARY |
---|---|---|---|---|
1 | Ramesh | 32 | Pune | 1000.00 |
2 | Khilan | 25 | Pune | 1000.00 |
3 | kaushik | 23 | Pune | 1000.00 |
4 | Chaitali | 25 | Pune | 1000.00 |
5 | Hardik | 27 | Pune | 1000.00 |
6 | Komal | 22 | Pune | 1000.00 |
7 | Muffy | 24 | Pune | 1000.00 |