Chat rosa xxx - Updating a record in mysql

The statement below would require that all 4 fields of the specified row be passed to the processing script.

updating a record in mysql-16

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.

Last modified 29-Apr-2016 14:01