mysql update is the most important field in a database
. Web building tips are the necessary solution for all developers.Once you insert data into mysql table then you need to modify the existing data. Because, updating statement is used to update existing data in a mysql table.
Here is an example of mysql query update given below using PHP script:
Suppose, an employee, namely, Jack Thompson in a reputed company has just had a birthday and he is now 22 years old. Now your job is to update his age using mysql commands like UPDATE, SET and WHERE.
Where UPDATE performs an update mysql query and the new values are to be placed into the mysql table following SET and WHERE clause represents limits which rows are affected.