How To Write Update Query In SQL

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

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.