Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.