9951 explained code solutions for 126 technologies


php-mysqlHow to update to null value in MySQL using PHP?


Updating a null value in MySQL using PHP can be done using the UPDATE statement. The following example code will update the name column of the users table to NULL if the id is 1:

$sql = "UPDATE users SET name = NULL WHERE id = 1";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

Output example

Record updated successfully

Code explanation

  • $sql: This is the SQL statement that will be used to update the name column of the users table to NULL if the id is 1.
  • $conn->query($sql): This is the function that will execute the SQL statement.
  • echo "Record updated successfully": This is the output that will be displayed if the record is updated successfully.
  • echo "Error updating record: " . $conn->error: This is the output that will be displayed if there is an error updating the record.

Helpful links

Edit this code on GitHub