MySQL Update Query

In this tutorial you will learn about the MySQL Update Query and its application with practical example.

The MySQL UPDATE statement is used to update column values of existing rows in a table with new values.Specific columns can be modified using the SET clause by supplying new values for those column. MySQL UPDATE statement can be used with WHERE clause to specify the conditions for the rows to update. Without using WHERE clause, all rows are updated.

MySql UPDATE Syntax:

 

In this tutorial we have learn about the MySQL Update Query and its application with practical example. I hope you will like this tutorial.