Introduction
In this article, we will learn how to write a SQL update query.
To modify the existing data in the SQL UPDATE statement is used.
Syntax
UPDATE TABLE_NAME SET column1 = value1, column2 = value2, ...columnN = ...valueN;
Note: Be careful when using the UPDATE statement. Here, all records in the table will be updated! To update only selected records The WHERE clause is used.
Example-1
The subsequent statement would update all records in the Article table with a single field (Title).
UPDATE Article SET Title = 'Introduction';
Example-2
The subsequent statement would update all records in the Article table with multiple fields (Id and Title).
UPDATE Article SET Id = 'A0', Title = 'Introduction';
Also, check How To Write Insert Query In SQL
