Update statement

UPDATE statement is used to change existing values in a table.


Syntax:
Update <table_name> set <column_name> = value [where clause]

e.g.
SQL> update employees set first_name='Johnson' where employee_id=901;


CAUTION: Update Statement without the WHERE clause will update all rows in the table.


Have a question or comment? Post it below!

Previous Tutorial   Next Tutorial