If we need to modify or update the data in MySQL, we can use the SQL UPDATE command to do so. The following is the general SQL syntax for the UPDATE command to modify MySQL data table data: You can update one or more fields at once. You can specify any condition in the WHERE clause. You can update the data at the same time in a single table. The WHERE clause is very useful when you need to update the data of a specified row in a data table. Update data from the command promptGrammar ¶
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]