Updating a field in mysql
Where column_name is the name of the column to be updated and new_value is the new value with which the column will be updated.
The following My SQL statement will update receive_qty, pub_lang, and receive_dt columns with new values 20, Hindi and 2008-07-10 if purch_price is more than 50.
This option takes a list of one or more partitions or subpartitions (or both).
(Bug #11758262, Bug #50439) See Section 126.96.36.199, “Determination of Safe and Unsafe Statements in Binary Logging”, for more information.
If you access a column from the table to be updated in an expression, assignments are generally evaluated from left to right.
If you omit the WHERE clause, all records in the table will be updated!
The WHERE clause specifies which record(s) that should be updated.