SQL UPDATE Query

SQL UPDATE clause is used to update OR change any existing data in the table through UPDATE query.

UPDATE query is basically used to modify the existing records in a table with the WHERE condition. The UPDATE query command update the selected rows through the WHERE condition only, otherwise all the rows would be affected.

SQL UPDATE Query Syntax

UPDATE table_name
SET column_1 = value_1, column_2 = value_2, ....
WHERE condition;

• Update records in a table very carefully.
• The WHERE condition is used to specifies which record(s) that would be going update.
• If you are appling WHERE condition then, all records in the table will be updated.

Employee Table

A sample of EMPLOYEE records table & the name of table Employee. The column(s) of the Employee table [ID, EMPLOYEE_NAME, EMPLOYEE_EMAIL, ADDRESS, CITY, and COUNTRY]:

UPDATE Query with WHERE condition

UPDATE Employee
SET EMPLOYEE_NAME = 'Minakshi Kapoor', EMAIL = 'minakshi@gmail.com
WHERE ID = 2;

Result Look Like

UPDATE Query without WHERE condition

If you want to modify the EMPLOYEE_NAME and EMPLOYEE_EMAIL column values in the Employee table without using WHERE condition, then UPDATE query full the same values for all. You can see the following table:

UPDATE Employee
SET EMPLOYEE_NAME = 'Minakshi Kapoor', EMAIL = 'minakshi@gmail.com;

Result Look Like