Add a new column to existing table in a migration

Question

I can t figure out how to add a new column to my existing database table using the Laravel framework   I tried to edit the migration file using      lt  php  public function up         Schema  create  users   function   table             table- gt integer  paid                In terminal  I execute php artisan migrate install and migrate   How do I add new columns

User · Answer

First rollback your previous migration  php artisan migrate rollback   After that  you can modify your existing migration file  add new   rename or delete columns  then Re-Run your migration file  php artisan migrate

User · Answer

Laravel 7  Create a migration file using cli command  php artisan make migration add paid to users table --table users  A file will be created in the migrations folder  open it in an editor   Add to the function up      Schema  table  users   function  Blueprint  table           Create new column        You probably want to make the new column nullable      table- gt integer  paid  - gt nullable  - gt after  status        Add to the function down    this will run in case migration fails for some reasons   table- gt dropColumn  paid     Run migration using cli command  php artisan migrate    In case you want to add a column to the table to create a foreign key constraint  In step 3 of the above process  you ll use the following code   table- gt bigInteger  address id  - gt unsigned  - gt nullable  - gt after  tel number      table- gt foreign  address id  - gt references  id  - gt on  addresses  - gt onDelete  SET NULL     In step 4 of the above process  you ll use the following code     1  Drop foreign key constraints  table- gt dropForeign   address id        2  Drop the column  table- gt dropColumn  address id

User · Answer

You can add new columns within the initial Schema  create method like this   Schema  create  users   function  table         table- gt integer  paied         table- gt string  title         table- gt text  description         table- gt timestamps          If you have already created a table you can add additional columns to that table by creating a new migration and using the Schema  table method   Schema  table  users   function  table         table- gt string  title         table- gt text  description         table- gt timestamps          The documentation is fairly thorough about this  and hasn t changed too much from version 3 to version 4

User · Answer

this things is worked on laravel 5 1   first  on your terminal execute this code  php artisan make migration add paid to users --table users   after that go to your project directory and expand directory database - migration and edit file add paid to users php  add this code  public function up         Schema  table  users   function  Blueprint  table              table- gt string  paid      just add this line             after that go back to your terminal and execute this command  php artisan migrate   hope this help

User · Answer

Add column to your migration file and run this command  php artisan migrate refresh --path  database migrations your file name php

User · Answer

Although a migration file is best practice as others have mentioned  in a pinch you can also add a column with tinker     php artisan tinker   Here s an example one-liner for the terminal   Schema  table  users   function  Illuminate Database Schema Blueprint  table    table- gt integer  paid            Here it is formatted for readability   Schema  table  users   function  Illuminate Database Schema Blueprint  table         table- gt integer  paid

User · Answer

I ll add on to mike3875 s answer for future readers using Laravel 5 1 and onward   To make things quicker  you can use the flag  --table  like this   php artisan make migration add paid to users --table  users    This will add the up and down method content automatically          Run the migrations         return void     public function up         Schema  table  users   function  Blueprint  table                           Similarily  you can use the --create  table name   option when creating new migrations which will add more boilerplate to your migrations  Small point  but helpful when doing loads of them

User · Answer

laravel 5 6 and above  in case you want to add new column as a FOREIGN KEY to an existing table   Create a new migration by executing this command   make migration  Example     php artisan make migration add store id to users table --table users     In database migrations folder you have new migration file  something like    2018 08 08 093431 add store id to users table php  see the comments    lt  php  use Illuminate Support Facades Schema  use Illuminate Database Schema Blueprint  use Illuminate Database Migrations Migration   class AddStoreIdToUsersTable extends Migration                  Run the migrations                 return void             public function up                 Schema  table  users   function  Blueprint  table                    1  Create new column                You probably want to make the new column nullable              table- gt integer  store id  - gt unsigned  - gt nullable  - gt after  password                    2  Create foreign key constraints              table- gt foreign  store id  - gt references  id  - gt on  stores  - gt onDelete  SET NULL                                      Reverse the migrations                 return void             public function down                 Schema  table  users   function  Blueprint  table                    1  Drop foreign key constraints              table- gt dropForeign   store id                     2  Drop the column              table- gt dropColumn  store id                            After that run the command    php artisan migrate     In case you want to undo the last migration for any reason  run this command    php artisan migrate rollback     You can find more information about migrations in the docs

User · Answer

To create a migration  you may use the migrate make command on the Artisan CLI   Use a specific name to avoid clashing with existing models   for Laravel 3   php artisan migrate make add paid to users   for Laravel 5    php artisan make migration add paid to users table --table users   You then need to use the Schema  table   method  as you re accessing an existing table  not creating a new one    And you can add a column like this   public function up         Schema  table  users   function  table             table- gt integer  paid                and don t forget to add the rollback option   public function down         Schema  table  users   function  table             table- gt dropColumn  paid                Then you can run your migrations   php artisan migrate   This is all well covered in the documentation for both Laravel 3    Schema Builder Migrations   And for Laravel 4   Laravel 5    Schema Builder Migrations   Edit   use  table- gt integer  paid  - gt after  whichever column    to add this field after specific column

User · Answer

If you re using Laravel 5  the command would be   php artisan make migration add paid to users   All of the commands for making things  controllers  models  migrations etc  have been moved under the make  command   php artisan migrate is still the same though

User · Answer

First you have to create a migration  you can use the migrate make command on the laravel artisan CLI Old laravel version like laravel 4 you may use this command for Laravel 4  php artisan migrate make add paid to users  And for laravel 5 version for Laravel 5   php artisan make migration add paid to users table --table users  Then you need to use the Schema  table     And you have to add the column  public function up           Schema  table  users   function  table              table- gt integer  paid                 further you can check this

User · Answer

WARNING this is a destructive action  If you use this ensure you back up your database first you can simply modify your existing migration file  for example adding a column in your table  and then in your terminal typing     php artisan migrate refresh

[php] Add a new column to existing table in a migration

Examples related to php

Examples related to laravel

Examples related to laravel-4

Examples related to laravel-migrations