Automattic\WooCommerce\Internal\Utilities

DatabaseUtil::generate_on_duplicate_statement_clause │ public │ WC 1.0

Generates ON DUPLICATE KEY UPDATE clause to be used in migration.

Method of the class: DatabaseUtil{}

No Hooks.

Returns

String. SQL clause for INSERT...ON DUPLICATE KEY UPDATE

Usage

$DatabaseUtil = new DatabaseUtil();
$DatabaseUtil->generate_on_duplicate_statement_clause( $columns ): string;

$columns(array) (required)

List of column names.

DatabaseUtil::generate_on_duplicate_statement_clause() DatabaseUtil::generate on duplicate statement clause code ^{WC 10.3.3}

public function generate_on_duplicate_statement_clause( array $columns ): string {
	$update_value_statements = array();
	foreach ( $columns as $column ) {
		$update_value_statements[] = "`$column` = VALUES( `$column` )";
	}
	$update_value_clause = implode( ', ', $update_value_statements );

	return "ON DUPLICATE KEY UPDATE $update_value_clause";
}