Cacher is the code snippet organizer for pro developers

db_update('node')
->fields(array(
  'status' => $status,
  'title' => 'Example'
))
->condition('created', REQUEST_TIME - 3600, '>=')
->execute();

$query = db_select('users', 'u');
$query->fields('u', array('name'));
$query->condition('u.uid', 0, '=');
$result = $query->execute()->fetchField();

db_merge('example')
  ->key(array('id' => $id))
  ->fields(array(
    'name' => $name,
))
->execute();

$nid = db_insert('node')
  ->fields(array(
    'title' => 'Example',
    'status' => $status
))->execute();

$num_deleted = db_delete('node')
  ->condition('nid', $nid)
  ->execute();