MySQL UPDATE

The UPDATE statement is used to modify data in a table.

Syntax:
UPDATE table_name
SET column=value, column1=value1,...
WHERE someColumn=someValue 
Example:

Earlier in the tutorial, we created a table named "Employee". Here is how it looks:

FirstNameLastNameSalary
Chrisbenoit5000
AnnaWeston8000

The following example updates some data in the "employee" table:

Example:
<?php
// Database connection establishment
    $con=mysqli_connect("example.com","alex","qwerty","db_name");
    
// Check connection
    if (mysqli_connect_errno($con)) {
    echo "MySQL database connection failed: " . mysqli_connect_error();
    }

    mysqli_query($con,"UPDATE employee SET salary = `10000`
         WHERE FirstName = `Anna` AND LastName = `Weston`");

?>  

After the update, the "employee" table will look like this:

FirstNameLastNameSalary
Chrisbenoit5000
AnnaWeston10000