Automattic\WooCommerce\Internal\Utilities
DatabaseUtil::generate_on_duplicate_statement_clause()
Generates ON DUPLICATE KEY UPDATE clause to be used in migration.
Method of the class: DatabaseUtil{}
No Hooks.
Return
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 9.6.1
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"; }