Updating Records via SQL Query in PHP

Let's now learn how to modify records. This is done using the UPDATE command. It has the following syntax:

php<?php
  $query = "UPDATE table SET field = value WHERE condition";
?>

Example

Let's change the age and salary of a user:

php<?php
  $query = "UPDATE users SET age=20, salary=800 WHERE id=1";
?>

Example

Set the salary to 400 and age to 24 for all users aged 23:

php<?php
  $query = "UPDATE users SET age=24, salary=300 WHERE age=23";
?>

Example

Without the WHERE command, updates will affect the entire table. For example, set the salary to 400 and age to 24 for all users:

php<?php
  $query = "UPDATE users SET age=24, salary=300";
?>