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.
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.
The subsequent statement would update all records in the Article table with a single field (Title).
UPDATE Article SET Title = 'Introduction';
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