Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Explain UPDATE Statement in SQL ?

This statement is used to change values of existing data in the database.

 

Syntax:

 

UPDATE table_name

SET columnname1 = value1  [, columname2 = value2]...

WHERE search_condition;

 

This statement checks the WHERE clause first. For all records in the given table in which the WHERE clause evaluates to TRUE, the corresponding value is updated.

 

Related Posts Plugin for WordPress, Blogger...
Flag Counter