The UPDATE Statement

In this section, you will learn use of the update statement.

The UPDATE Statement

The UPDATE Statement

     

The UPDATE statement is used to modify the data in the database table through a specified criteria. In the given syntax of update statement the keyword SET is used to assign a new value to a selected columns. The statement also uses WHERE clause. 

It simply work as a select statement, if the given criteria match with the table content then the selected row will be effected if not then the whole table will be effected.

Lets consider a record with a emp_name of "Amar" as shown below.

 

 

 

 

emp_name Position Salary email_id
Amar Designer 8000 [email protected]

If we want to change the salary to the employee with a emp_name of "Amar" then we should use the following SQL statement :

Syntax:

UPDATE 'table_name' SET 'field_name' = 'new_value'
WHERE 'field_name' = 'field_value';

for example: 
 
UPDATE Person SET Salary = 10000
WHERE emp_name = 'Amar';

The output of the above code will be :

emp_name Position Salary email_id
Amar Designer 10000 [email protected]


To Update several Columns in a Row: If we want to change the multiple values of a table like in employee table we want to change Position and email_id then we have to write the following code in which we set the email_id and position by SET keyword and putting condition by keyword WHERE for emp_name is 'Amar'. 

UPDATE employee
SET email_id = '[email protected]', Position = 'Programmer'
WHERE emp_name = 'Amar';

The output of the above code will be:

emp_name Position Salary email_id
Amar Programmer 10000 [email protected]

Tutorials

  1. SQL Alter Table Primary Key tutorial
  2. SQL Date, SQL Date Examples
  3. MySql Remove Tutorials
  4. PHP SQL Timestamp
  5. Mysql Date in where clause
  6. MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
  7. MySQL Examples, Learn MySQL with examples.
  8. MySQL Injection
  9. Mysql Update command
  10. Mysql Trigger After Delete
  11. Mysql Date Part Only
  12. MySQL Append Column
  13. SQL-introduction
  14. Data Normalization
  15. Create a database
  16. The INSERT INTO Statement
  17. The UPDATE Statement
  18. The DELETE Statement
  19. The SELECT statement for SQL
  20. WHERE Statement in SQL
  21. Aggregate Functions
  22. SQL Example, Codes and Tutorials
  23. SQL for Beginner
  24. SQL Introduction
  25. Create Table in Database
  26. Insert Records in Table
  27. Select data from Table in Database
  28. Update Records in Database
  29. Delete a Records in Database
  30. Where Clause in SQL
  31. Drop Table in Database
  32. SQL UNION ALL Operator
  33. SQL Right JOIN
  34. SQL BETWEEN Operator
  35. SQL AND Statement
  36. SQL Add Column Position
  37. SQL Example, Codes and Tutorials
  38. SQL % Wildcards
  39. SQL UNIQUE Constraint
  40. SQL UNION Operator