Update allows user to change multiple fields - Database

Discussion

• Nirja Shah   -Posted on 02 Nov 15
  - The UPDATE Query is used to modify the existing records in a table.
  
  - WHERE clause can be used with UPDATE query to update selected rows otherwise all the rows would be affected.
  
  - Syntax:
  The basic syntax of UPDATE query with WHERE clause is as follows:
  
  UPDATE table_name
  SET column1 = value1, column2 = value2...., columnN = valueN
  WHERE [condition];
  
  - A combination of N number of conditions using AND or OR operators can be used.

➨ Post your comment / Share knowledge