How Update Table With Example

UPDATE statement:

  • The UPDATE statement updates data values in a database.
  • UPDATE can update one or more records in a table.
  • Use the WHERE clause to UPDATE only specific records.

Syntax:


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