Method: Sequel::MySQL::Dataset#delete_sql

Defined in:
lib/sequel_core/adapters/mysql.rb

#delete_sql(opts = nil) ⇒ Object

MySQL supports ORDER and LIMIT clauses in DELETE statements.



440
441
442
443
444
445
446
447
448
449
450
451
452
 
# File 'lib/sequel_core/adapters/mysql.rb', line 440

def delete_sql(opts = nil)
  sql = super
  opts = opts ? @opts.merge(opts) : @opts

  if order = opts[:order]
    sql << " ORDER BY #{column_list(order)}"
  end
  if limit = opts[:limit]
    sql << " LIMIT #{limit}"
  end

  sql
end