Home >Database >Mysql Tutorial >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:https://www.php.cn/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!