UPDATE query in MySQL

MySQL UPDATE

In MySQL, the UPDATE statement is used to update the data of a table in a database.

Syntax:

UPDATE table_name
SET column_1 = expr_1,  
    column_2 = expr_2,  
    ...  
    column_n = expr_n  
WHERE conditions;

Example 1: Updating a single column of a table. Items table before update:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	100
4	Grocery	90
5	Toys	50

UPDATE items  
SET quantity = 60  
WHERE id = 5;

Explanation: The record of the ‘quantity’ column will be updated to 60 in the row where the value of the ‘id’ column is 5. To check the output, execute the below query. SELECT * FROM items;

The items table after the update will be like this:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	100
4	Grocery	90
5	Toys	60

 

Example 2: Updating multiple columns of a table. Items table before update:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	100
4	Grocery	90
5	Toys	50

UPDATE items  
SET name = ‘Cosmetics’, quantity = 60
WHERE id = 5;

Explanation: The record of the ‘name’ column will be updated to ‘Cosmetics’ and the record of the ‘quantity’ column will be updated to 60 in the row where the value of the ‘id’ column is 5. To check the output, execute the below query. SELECT * FROM items;

The items table after the update will be like this:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	100
4	Grocery	90
5	Cosmetics	60