MysqliSqlHelper::prepareMerge

public function prepareMerge($tableName, array $primaryFields, array $insertFields, array $updateFields)
{
	$insert = $this->prepareInsert($tableName, $insertFields);
	$update = $this->prepareUpdate($tableName, $updateFields);

	if (
		$insert && $insert[0] != "" && $insert[1] != ""
		&& $update && $update[1] != ""
	)
	{
		$sql = "
			INSERT INTO ".$this->quote($tableName)." (".$insert[0].")
			VALUES (".$insert[1].")
			ON DUPLICATE KEY UPDATE ".$update[0]."
		";
	}
	else
	{
		$sql = "";
	}

	return array(
		$sql
	);
}