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 thename
column of theusers
table toNULL
if theid
is1
.$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
More of Php Mysql
- How to use a variable in a MySQL query using PHP?
- How to change database in MySQL with PHP?
- How to get the version of MySQL using PHP?
- How to create an SSL connection to MySQL using PHP?
- How to use utf8mb4_unicode_ci in MySQL with PHP?
- How to check the result of an insert in PHP and MySQL?
- How to use MySQL transactions in PHP?
- How to get a single value from query in PHP MySQL?
- How to get table column names in PHP MySQL?
See more codes...