Check out example codes for "MySQL UPDATE". It will help you in understanding the concepts better.

Code Example 1

UPDATE tableName SET anAttribute = 'Something' WHERE anOtherAttribute = 'SomethingElse'

//All 'SomethingElse' values will become 'Something'

Code Example 2

UPDATE table_name

SET column1=value, column2=value2,...

WHERE some_column=some_value 

Code Example 3

UPDATE table_name

 SET column1 = value1, column2 = value2, ...

 WHERE condition;

Code Example 4

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

Code Example 5

UPDATE [LOW_PRIORITY] [IGNORE] table_name 
SET 
    column_name1 = expr1,
    column_name2 = expr2,
    ...
[WHERE
    condition];

Code Example 6

The UPDATE statement updates data in a table. It allows you to change the values in one or more columns of a single row or multiple rows.

The following illustrates the basic syntax of the UPDATE statement:

UPDATE [LOW_PRIORITY] [IGNORE] table_name 
SET 
    column_name1 = expr1,
    column_name2 = expr2,
    ...
[WHERE
    condition];
In this syntax:

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. To update values in multiple columns, you use a list of comma-separated assignments by supplying a value in each column’s assignment in the form of a literal value, an expression, or a subquery.
Third, specify which rows to be updated using a condition in the WHERE clause. The WHERE clause is optional. If you omit it, the UPDATE statement will modify all rows in the table.

Learn ReactJs, React Native from akashmittal.com