Update Query example for Mysql Database

Update Query is used to modify the existing record of  table data.Update query can be performed in two ways

1.Multiple row updates
2.Single row update

Example Table : For your reference

Table Name : Human


Human

Id	Gender	Age	Name
1	Male	18	Sam Anderson
2	Female	24	Samoel
3	Male	16	Jamen
4	Male	26	Kamel
5	Female	32	Jami

The above table name is Human and it has four columns likely named Id, Gender, Age and Name  and it has five rows or records and if you want to modify data then use mysql update query 

Syntax

Query : UPDATE table_name SET column_name1=value1,column_name2=value2,...  WHERE column_name3=value3

1.Multiple Row Update- UPDATE QUERY

Query : UPDATE  human SET Age=20  WHERE Gender=Male

After executing the above query 3 records will be update because Gender column has 3 male record data and it is not a primary key column that's why its update multiple record.

Human

Id	Gender	Age	Name
1	Male	20	Sam Anderson
2	Female	24	Samoel
3	Male	20	Jamen
4	Male	20	Kamel
5	Female	32	Jami

2.Single Row Update - UPDATE QUERY

Query : UPDATE human SET Age=40 WHERE Id=4


After executing the above query only 1 record will be updated because Id column has only 1 record data and it is primary key column that's why it will update only one record.


Human

Id	Gender	Age	Name
1	Male	20	Sam Anderson
2	Female	24	Samoel
3	Male	20	Jamen
4	Male	40	Kamel
5	Female	32	Jami