mysql update

1UPDATE table_name
2SET variable = 'changed field', variable = 'another changed field'
3WHERE firstline_name = 1;

1UPDATE table_name SET field1 = 'value 1', field2 = 'value 2'
2WHERE field3 = 'value 3'
3

1UPDATE table
2SET nom_colonne_1 = 'nouvelle valeur'
3WHERE condition

1-- Set New Employee Password 
2UPDATE employee
3SET employee.password = '1234'
4WHERE employee.email = 'emp@gmail.com';

1The 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.
2
3The following illustrates the basic syntax of the UPDATE statement:
4
5UPDATE [LOW_PRIORITY] [IGNORE] table_name 
6SET 
7    column_name1 = expr1,
8    column_name2 = expr2,
9    ...
10[WHERE
11    condition];
12In this syntax:
13
14First, specify the name of the table that you want to update data after the UPDATE keyword.
15Second, 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.
16Third, 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.

1UPDATE table_name SET field1 = new-value1, field2 = new-value2
2[WHERE Clause]
3