What is the statement to modify data in MySQL?

The key statement for MySQL to modify data is "UPDATE"

The syntax is as follows:

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

First open the mysql tool (use Navacate for mysql as an example)

Download address://m.sbmmt.com/xiazai/gongju/757

Then select to test table, click [Query]-》[New Query]

Then enter the sql modification statement:

Finally Check whether the data in the table has changed.

Related references:php中文网

The above is the detailed content of What is the statement to modify data in MySQL?. For more information, please follow other related articles on the PHP Chinese website!