Update data from a Table

                                                                             The UPDATE statement is used to update existing data in a table.


Syntax
UPDATE table
SET column1=value, column2=value2
WHERE some_column=some_value




Update specify data 


UPDATE first
SET id='001', data='Jaya'
WHERE LastName='jayarathna' AND FirstName='praneeth';


    


Normal update code

UPDATE first
SET id='001', data='praneeth';