Method: Myq::Core#make_duplicate_key_update_sql

Defined in:
lib/myq/core.rb

#make_duplicate_key_update_sql(update_columns) ⇒ Object



38
39
40
41
42
43
44
45
# File 'lib/myq/core.rb', line 38

def make_duplicate_key_update_sql(update_columns)
  return "" if update_columns.empty?
  updates = []
  update_columns.each do |update_column|
    updates << "#{update_column}=VALUES(\`#{update_column}\`)"
  end
  "ON DUPLICATE KEY UPDATE " + updates.join(', ')
end