SQL UPDATE: Modify Column Data

To modify the data in a particular column, you can use the UPDATE statement. Here is an example:

UPDATE 表名
SET 列名 = 新值
WHERE 条件;

For example, if you want to change the value of the “age” column in the row named “John” in the table to 30, you can write it like this:

UPDATE users
SET age = 30
WHERE name = 'John';

This will update the age of the user named “John” to 30 years old.