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:

FirstName LastName Salary
Chris benoit 5000
Anna Weston 8000

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:

FirstName LastName Salary
Chris benoit 5000
Anna Weston 10000
Found This Page Useful? Share It!
Get the Latest Tutorials and Updates
Join us on Telegram
Keep W3schools Growing with Your Support!
❤️ Support W3schools