MySQL UPDATE: Modifying Data in Tables

To amend data in a MySQL table, you can use the UPDATE statement. Here is the basic syntax for modifying data in a table:

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

The table name refers to the name of the table where the data will be modified, the column name refers to the name of the column to be modified, the value is the new value to be updated, and the condition is the criteria used to select the rows to be updated.

For example, suppose there is a table called users, with columns id, name, and age. If we want to update the name to “John” and age to 30 for the row with id 1, we can use the following statement:

UPDATE users
SET name = 'John', age = 30
WHERE id = 1;

This will update the values in the name and age columns of the row with id 1 in the table.

Caution: If no WHERE condition is specified, the UPDATE statement will modify data in all rows of the table. Therefore, when performing an update operation, it is important to be cautious and ensure that the WHERE condition is specified correctly.