rails migration execute sql code example

Example 1: rails execute sql

results = ActiveRecord::Base.connection.exec_query(sql)

Example 2: using SQL in rails migration

def change
  execute <<-SQL
    UPDATE table1
    SET column1 = "value"
  SQL
end