MySQL modify data table sql statement
Mysql uses update to modify data, and UPDATE statements to change the column values of a single row, a set of rows, or all rows in a table. The usage of update is described in detail below
1 update model UPDATE table_name
SET
Column_name1 = expr1
Column_name2 = expr2
...
WHERE
Condition
2 UPDATE employees update statement to change a single row in the table
SET
Email = 'mare@dc3688.com'
WHERE
EmployeeNumber = 10
3 update statement to change the UPDATE employees of multiple rows in the table
SET
Lastname = 'Hill'
Email = 'marr@dc3688.com'
WHERE
EmployeeNumber = 16
Note the UPDATE statement to update the data in the database table. The article is from http://www.dc3688.com.
