Here's how to update existing data into MySQL database table.
update table set column='new_value' where where_condition;
The update statement updates columns of existing rows in the table with new values.
The table is the table name.
The set clause indicates which column to modify and the values they should be given.
The where clause specifies the conditions that identify which rows to update. Its very useful if you want to update selected rows in a table.
Example: