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
IdGenderAgeName
1Male18Sam Anderson
2Female24Samoel
3Male16Jamen
4Male26Kamel
5Female32Jami

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
IdGenderAgeName
1Male20Sam Anderson
2Female24Samoel
3Male20Jamen
4Male40Kamel
5Female32Jami

Comments

Popular posts from this blog

Database Multi Language Support Format

Five More Indian Languages - Google Translate