UPDATE

Syntax

• UPDATE [ LOW_PRIORITY ] [ IGNORE ] tableName SET column1 = expression1,

column2 = expression2,
...

[WHERE conditions]; //Simple single table update

• UPDATE [ LOW_PRIORITY ] [ IGNORE ] tableName SET column1 = expression1,

column2 = expression2,
...

[WHERE conditions] [ORDER BY expression [ ASC | DESC ]] [LIMIT row_count]; //Update with order by and limit

• UPDATE [LOW_PRIORITY] [IGNORE] table1, table2, …

SET column1 = expression1,
    column2 = expression2,
    ...
[WHERE conditions];  //Multiple Table update