The SQL UPDATE Query is used to modify the existing records in a table.

You can use WHERE clause with UPDATE query to update selected rows otherwise all the rows would be effected.

Syntax Of Update Query:

The basic syntax of UPDATE query with WHERE clause is as follows:

[sql] UPDATE table_name
SET column1 = value1, column2 = value2…., columnN = valueN
WHERE [condition];
Vivek Vengala

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 0 comments

Leave a Reply: