More than 5 years have passed since last update.

【Rails】 DBのcolumnをstringからintegerにする方法

Rails

Last updated at 2019-04-10Posted at 2019-02-22

Railsでchange_columnを使用し、string→integerにする時につまったのでメモ

...
  def up
    change_column :table_name, :column_name, 'integer USING CAST(column_name AS integer)'
  end

  def down
    change_column :table_name, :column_name, :string
  end
...

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up