`UPDATE` Query in DBMS (MySQL) [ English ]

Languages

• English

Introduction

In a Database Management System (DBMS), data stored in tables may need to be modified or corrected over time. For example, a student's course may change, or an employee’s salary may be updated. The UPDATE statement is used to modify existing records in a table.

This command allows users to change the value of one or more columns in specific rows of a table.

Definition

The UPDATE query is a Data Manipulation Language (DML) command used to modify or update existing records in a table.

Syntax

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Where:

• table_name – The name of the table where records will be updated.
• column1, column2 – The columns whose values will be modified.
• value1, value2 – The new values assigned to the columns.
• condition – Specifies which records should be updated.

How It Works

When the UPDATE command is executed:

1. The DBMS locates the specified table.
2. It identifies the rows that satisfy the WHERE condition.
3. The specified column values are modified.
4. The table is updated with the new values.

Example Table

Suppose we have a students table.

Example 1: Updating a Specific Record

UPDATE students
SET course = 'BCom'
WHERE id = 2;

Result

The course of the student with id = 2 is updated from BBA to BCom.

Example 2: Updating Multiple Columns

UPDATE students
SET age = 22, course = 'BBA'
WHERE id = 1;

This query updates two columns for the student with id = 1.

Updating All Records

If the WHERE clause is omitted, all records in the table will be updated.

Example:

UPDATE students
SET course = 'BCA';

This command will update the course for every student in the table.

⚠ Warning: Omitting the WHERE clause may unintentionally modify all records.

Important Notes

• Always use the WHERE clause to update specific records.
• The UPDATE command modifies existing data without creating new records.
• Multiple columns can be updated in a single query.

Key Points

• UPDATE is a DML command.
• It is used to modify existing records in a table.
• The SET clause specifies the new values.
• The WHERE clause determines which rows are updated.

Summary

The UPDATE command is used to modify existing data stored in a database table. By specifying the columns and conditions, users can update specific records efficiently. Proper use of the WHERE clause ensures that only the intended records are modified.