Go to Qiita Advent Calendar 2024 Top
LoginSignup
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

@kudojp(Daiki Kudo)

RailsのDBマイグレーションの細々したメモ

Posted at

railsのマイグレーションのファイルにexecute "生SQl"を生SQLを入れられる

    execute 'UPDATE posts SET start_at = created_at WHERE start_at IS NULL'
    change_column_null :posts, :start_at, false

NOT NULL制約をマイグレーションで加える際は

    change_column_null :customer_news, :name, false, '既存のnullを置き換える値', default: 'デフォルトさん'

MySQL5.6ではtext型、blob型のカラムのNOT NULL制約のデフォルト値を設定できない

  • ''(空文字)がデフォルトになりそう??
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?