MySQL UPDATE First, specify the name of the table that you want to update data after the UPDATE keyword. Second, specify which column you want to update and the new value in the SET clause. ... Third, specify which rows to be updated using a condition in the WHERE clause.