sql UPDATE statement
The UPDATE statement is used in updating existing records in a table.
The following is the SQL UPDATE Syntax
UPDATE myTable
SET myColumn1=myValue1, myColumn2=myValue2,...
WHERE column_name=some_value
The WHERE clause in the UPDATE syntax specifies which record or records will be updated. If the WHERE clause is omitted, all records will be updated.
this has been simple and helpful.
thanks a lot.