How can the INSERT ... ON DUPLICATE KEY UPDATE statement be effectively used in PHP for database operations?

When performing database operations in PHP, the INSERT ... ON DUPLICATE KEY UPDATE statement can be effectively used to handle situations where a duplicate key violation occurs. This statement allows you to insert a new row into a table, or update an existing row if a duplicate key constraint is violated. This can be useful for scenarios where you want to insert a new record if it doesn't already exist, or update an existing record if it does. 

<?php
// Assuming $conn is the database connection object

// Define the SQL query using INSERT ... ON DUPLICATE KEY UPDATE
$sql = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2') 
        ON DUPLICATE KEY UPDATE column2 = 'new_value'";

// Execute the SQL query
if ($conn->query($sql) === TRUE) {
    echo "Record inserted or updated successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Close the database connection
$conn->close();
?>

Keywords

PHP INSERT ON DUPLICATE KEY UPDATE database operations error types

Related Questions