prepareMerge

array public
\Bitrix\Main\DB\SqlHelper::prepareMerge(
 string $tableName,
 array $primaryFields,
 array $insertFields,
 array $updateFields
);

This non-static method builds the strings for the SQL MERGE command for the specified table.

Parameter	Description	Version
$tableName	Table name
$primaryFields	Array of primary keys for list of columns: Array("column")[]
$insertFields	What to insert: Array("column" => $value)[]
$updateFields	How to update: Array("column" => $value)[]