How do I update data in MySQL

To update data in MySQL, you can use the UPDATE statement. This statement allows you to modify existing records in a table. Below is a general syntax for the UPDATE statement followed by an example.

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

Here's an example where we update the salary of an employee in the employees table:

            UPDATE employees
            SET salary = 50000
            WHERE employee_id = 1;