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.
If we want to change the salary to the employee with a emp_name of "Amar" then we should use the following SQL statement :
The output of the above code will be :
The output of the above code will be: