#mysqlでテーブルにカラムを追加する方法
##まずテーブルの確認
![3156f9c2f06fea6af08836bcaab540b4[1].png](https://qiita-user-contents.imgix.net/https%3A%2F%2Fqiita-image-store.s3.ap-northeast-1.amazonaws.com%2F0%2F457880%2Fa530180a-c76a-28e9-6443-f851f54a3899.png?ixlib=rb-4.0.0&auto=format&gif-q=60&q=75&s=1f7e66a98cd73a413169e05dbad26802)
ここでカラムが足りない事に気づいたら
##migrateとrollback
php artisan migrate:rollback --step 3で3つ前にprofilesで使用したmigrateにrollbackする
![70e9e0e4f424c1270c6408f799d47f9b[1].png](https://qiita-user-contents.imgix.net/https%3A%2F%2Fqiita-image-store.s3.ap-northeast-1.amazonaws.com%2F0%2F457880%2F148195ea-641e-0b8a-a61a-e37807bde301.png?ixlib=rb-4.0.0&auto=format&gif-q=60&q=75&s=d2e2a45cf5a827a266057a6d0dbbccd5)
##migrationディレクトリに必要なカラムを追加する。
![a6e0f84b36cb07d90087afd0a1551549[1].png](https://qiita-user-contents.imgix.net/https%3A%2F%2Fqiita-image-store.s3.ap-northeast-1.amazonaws.com%2F0%2F457880%2Fec02cfd3-8e0d-ed94-aa86-de9727ed86be.png?ixlib=rb-4.0.0&auto=format&gif-q=60&q=75&s=d0e1c7b5b2d51f08ddf11a0852516e84)
##再度migrateする
![18b5dc1d15503a26b9c02335a0b36358[1].png](https://qiita-user-contents.imgix.net/https%3A%2F%2Fqiita-image-store.s3.ap-northeast-1.amazonaws.com%2F0%2F457880%2F0be65cb6-d2c1-aba6-9f94-e5e8377eb3ff.png?ixlib=rb-4.0.0&auto=format&gif-q=60&q=75&s=2af5968c506765a894d13ed77727d36e)
これでカラムの追加完了
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme