MySQL UPDATE Guide: Modify Data Easily

1 year ago
Liam
1 minute

To modify data in MySQL, you can use the UPDATE statement. The syntax is as follows:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

table_name is the name of the table where the data will be modified, column1, column2, etc. represent the column names to be modified, value1, value2 are the new values to be updated, and condition is the criteria for selecting the rows to be modified.

For example, to change the age of the record with the name ‘John’ in the table to 30, you can write it like this:

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

Before executing the UPDATE statement, be sure to carefully consider the conditions to avoid modifying data that should not be modified.

bannerAds