8.4.x database.inc db_update($table, array $options = [])
8.0.x database.inc db_update($table, array $options = array())
8.1.x database.inc db_update($table, array $options = array())
8.2.x database.inc db_update($table, array $options = array())
8.3.x database.inc db_update($table, array $options = [])
8.5.x database.inc db_update($table, array $options = [])
7.x database.inc db_update($table, array $options = array())

Returns a new UpdateQuery object for the active database.


string $table: The table to update.

array $options: An array of options to control how the query operates.

Return value

\Drupal\Core\Database\Query\Update A new Update object for this connection.


as of Drupal 8.0.x, will be removed in Drupal 9.0.0. Instead, get a database connection injected into your service from the container and call update() on it. For example, $injected_database->update($table, $options);

See also



Related topics

43 calls to db_update()
AggregatorCronTest::testCron in core/modules/aggregator/tests/src/Functional/AggregatorCronTest.php
Adds feeds and updates them via cron process.
DatabaseStorageTest::update in core/tests/Drupal/KernelTests/Core/Config/Storage/DatabaseStorageTest.php
drupal-7.contact.database.php in core/modules/contact/tests/drupal-7.contact.database.php
Database additions for Drupal\contact\Tests\ContactUpgradePathTest.
hook_ENTITY_TYPE_update in core/lib/Drupal/Core/Entity/entity.api.php
Respond to updates to an entity of a particular type.
hook_entity_update in core/lib/Drupal/Core/Entity/entity.api.php
Respond to updates to an entity.

... See full list


core/includes/database.inc, line 209
Core systems for the database layer.


function db_update($table, array $options = []) {
  if (empty($options['target']) || $options['target'] == 'replica') {
    $options['target'] = 'default';
  return Database::getConnection($options['target'])->update($table, $options);