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:
|
1 2 |
UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause] |
