1.20.x query.inc public MergeQuery::key(array $fields, array $values = array())

Sets the key field(s) to be used as conditions for this query.

This method should only be called once. It may be called either with a single associative array or two indexed arrays. If called with an associative array, the keys are taken to be the fields and the values are taken to be the corresponding values to set. If called with two arrays, the first array is taken as the fields and the second array is taken as the corresponding values.

The fields are copied to the condition of the query and the INSERT part. If no other method is called, the UPDATE will become a no-op.


$fields: An array of fields to set, or an associative array of fields and values.

$values: An array of values to set into the database. The values must be specified in the same order as the $fields array.

Return value

MergeQuery: The called object.


includes/database/query.inc, line 1504
Non-specific Database query code. Used by all engines.


General class for an abstracted MERGE query operation.


public function key(array $fields, array $values = array()) {
  if ($values) {
    $fields = array_combine($fields, $values);
  foreach ($fields as $key => $value) {
    $this->insertFields[$key] = $value;
    $this->condition($key, $value);
  return $this;