How to modify specific content in a table in MySQL?

To change specific content in a table in MySQL, you can use the UPDATE statement. Below is an example of using the UPDATE statement to modify specified content in a table.

UPDATE 表名
SET 列名1 = 新值1, 列名2 = 新值2, ...
WHERE 条件;

The table name refers to the name of the table to be modified; the column name refers to the name of the column to be modified; the new value is the value to be set; the condition is an optional WHERE clause used to specify the rows to be modified.

For example, let’s say we have a table called “customers” with columns “customer_id”, “customer_name”, and “city”. If we want to change the “customer_name” of the row with “customer_id” of 1 to “John”, we can use the following UPDATE statement:

UPDATE customers
SET customer_name = 'John'
WHERE customer_id = 1;

This will update the “customer_name” column of the row in the “customers” table with a “customer_id” of 1 to “John”.

Please modify table names, column names, new values, and conditions as needed.