The statement below would require that all 4 fields of the specified row be passed to the processing script.
Here is generic SQL syntax of UPDATE command to modify data into My SQL table: The WHERE clause is very useful when you want to update selected rows in a table.
This will use SQL UPDATE command with WHERE clause to update selected data into My SQL table tutorials_tbl.
Following example will update tutorial_title field for a record having tutorial_id as 3.
You supply the value in each column’s assignment in the form of a literal value, an expression, or a subquery.
Third, you specify which rows will be updated using a condition in the WHERE clause.