Update « Insert Update Delete « MySQL Tutorial

7.4.1.Syntac for UPDATE statement
7.4.2.UPDATE-ing Records
7.4.3.Change multiple columns using one statement
7.4.4.Update a value based on the value it currently holds
7.4.5.Use the LIMIT function to control the number of rows that are affected by your UPDATE statement
7.4.6.Update two tables in one update statement
7.4.7.Update only 5 records