How can the "INSERT ... ON DUPLICATE KEY UPDATE" functionality in MySQL be utilized to improve efficiency in PHP scripts?

When inserting data into a MySQL database using PHP scripts, the "INSERT ... ON DUPLICATE KEY UPDATE" functionality can be utilized to improve efficiency by avoiding duplicate entries. This feature allows you to insert a new row into a table, but if a duplicate key already exists, it will update the existing row instead of throwing an error. 

// Connect to database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Prepare SQL statement with ON DUPLICATE KEY UPDATE
$sql = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2') 
        ON DUPLICATE KEY UPDATE column2 = 'value2'";

// Execute SQL statement
$mysqli->query($sql);

// Close database connection
$mysqli->close();

Keywords

PHP MySQL INSERT ON DUPLICATE KEY UPDATE efficiency

Related Questions