MySQL Update Statement

UPDATE statement updates / edits the values in specified rows.

MySQL UPDATE Syntax 
UPDATE table_name SET Column_Name= Value1 WHERE Condition = Value; 

 

Example

ID Product Name Price £ Description
1 3D Glasses 14.49 High quality 3D glasses for 3D projectors.
2 Projector 400 HD and 3D ready Home teather projector.
3 Projector Screen 60 Perfect home teather experience with 90'' screen.
4 Sound System 800
High quality sound system.

Lets update the 4th row Product Name Column value 'Sound System' to 'Super Sound System'.

mysql> UPDATE products SET product_name ='Super Sound System'
-> WHERE price=800;
ID Product Name Price £ Description
1 3D Glasses 14.49 High quality 3D glasses for 3D projectors.
2 Projector 400 HD and 3D ready Home teather projector.
3 Projector Screen 60 Perfect home teather experience with 90'' screen.
4 Super Sound System 800
High quality sound system.