rails g迁移添加列
$ rails generate migration AddDetailsToProducts part_number:string price:decimal
如何创建迁移rails
rails g migration AddPartNumberToProducts
activerecord添加列
class AddPartNumberToProducts < ActiveRecord::Migration[6.0]
def change
add_column :products, :part_number, :string
end
end
ruby on rails db migrate
rails db:migrate
如何在ruby中创建SQL表
def self.create_table
sql = <<-SQL
CREATE TABLE IF NOT EXISTS IF NOT EXISTS students (
name TEXT,
grade TEXT
)
SQL
DB[:conn].execute(sql)
end