Database Merge, Insert or Update if exist. | Drupal 8

Database Merge, Insert or Update if exist.

By editor, 28 November, 2015
Question

How to merge (Insert or Update if exist) On drupal 8.

Merge SQL data base: Insert field or update if exist

$con = Database::getConnection();

$query = $con->merge('the_table_name')

    ->key(array('ref' => $ref))

    ->insertFields(array(

      'ref' => $ref,

      'count' => 1,

      'create' => time(),

    ))

    ->updateFields(array(

      'update' => time(),

      'name' => $name,

      'status' => $status,

    ))

   ->expression('count', 'count + :inc', array(':inc' => 1));

$return_value = $query->execute();

Tags

Database Basic Examples (Select, Merge, Insert ...)

Comments3

About text formats

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.

Chris (not verified)

7 years 11 months ago

This is super cool and to-the-point; however, you've got a semi-colon after updateFields(); ... but then an ->expression() call. 

For my needs I didn't need the ->expression so just removed it. 

editor

7 years 11 months ago

Hi Chris, Thank you for the correction, If you want to add expression or any other method, you can also do like:

$query ->expression('count', 'count + :inc', array(':inc' => 1));

Chris Happy (not verified)

7 years ago

Warning: don't use the column name `created`. It has caused a MySQL error in Drupal 8.4.0:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create ...