heredoc_hash.rb

  {:default => <<-DEFAULT_SQL.strip, :mysql => <<-MYSQL.strip}
 
  UPDATE users SET item_count = item_count + 1
  WHERE id IN (SELECT user_id FROM buckets WHERE id = NEW.bucket_id)
  DEFAULT_SQL
 
  UPDATE users, buckets SET item_count = item_count + 1
  WHERE users.id = user_id AND buckets.id = NEW.bucket_id
  MYSQL