How to add new column to existing table in laravel

Question

I am adding new column name title in my table tasks. But I am getting an error that this column does not exist in that table. Can anybody help me to resolve that error. Here is my code:

php artisan make:migration add_title_to_tasks_table --table="tasks" and then added this code

Schema::table('tasks', function (Blueprint $table) { 
  $table->string('title');
});

to new table file created

Are you using migrations? Check - https://laravel.com/docs/5.6/migrations — Sougata Bose, Mar 06 '18 at 11:36
yes i used php artisan make:migration add_title_to_tasks_table --table="tasks" — Nisha Sharma, Mar 06 '18 at 11:37
You need to alter the table and add the new columns. Then migrate again. — Sougata Bose, Mar 06 '18 at 11:37
You'd need to make a new migration to reflect the changes you want to make. Then run `php artisan migrate` to "push" the changes to you database. — brombeer, Mar 06 '18 at 11:38
can you please share your create table and alter table migration code — Mayank Majithia, Mar 06 '18 at 11:38
php artisan make:migration add_title_to_tasks_table --table="tasks" and then added Schema::table('tasks', function (Blueprint $table) { $table->string('title'); }); to that new table file created — Nisha Sharma, Mar 06 '18 at 11:40
https://stackoverflow.com/questions/16791613/add-a-new-column-to-existing-table-in-a-migration check this link you will find the answer for your question. — Arunachalam E, Mar 06 '18 at 12:05

score 4 · Answer 1 · answered Mar 06 '18 at 11:52

4

To Alter table and add column.

     /**
     * Run the migrations.
     *
     * @return void
     */
    public function up() {
        Schema::table('tasks', function (Blueprint $table) {

            $table->string('title')->after('id');

           // to change column datatype or change it to `nullable` 
           // or set default values , this is just example

           $table->string('title')->default('Test')->change(); 

        });
    }

You can refere documentation here, Laravel Migration

answered Mar 06 '18 at 11:52

Mayank Majithia

1,916
16
21

getting this error: "SQLSTATE[HY000]: General error: 1 table tasks has no column named title (SQL: insert into "tasks" ("title", "description", "user_id", "updated_at", "created_at" ▶" – Nisha Sharma Mar 06 '18 at 11:55
is your migration run successfully ? match table structure with your requirement. – Mayank Majithia Mar 06 '18 at 11:56
In order to modify an existing column, there is a dependency that one has to install.. `Doctrine/DBAL` https://laravel.com/docs/5.6/migrations#modifying-columns – Saiyan Prince Mar 06 '18 at 11:57
i installed dependency but still same issue – Nisha Sharma Mar 06 '18 at 12:09
@NishaSharma, if your comment is related to my answer/post, please add your comment there.. It is bit confusing for me to recognize as to whether you are referring to my post or Mayank's post – Saiyan Prince Mar 06 '18 at 12:17
@SaiyanPrince i tried migartion php artisan make:migration add_title_to_tasks_table --table="tasks" and then added your code to that file and run php artisan migrate but getting error that tasks table already exists – Nisha Sharma Mar 06 '18 at 12:20
Can anyone help me – Nisha Sharma Mar 07 '18 at 04:37
I know this will work. But i need alternate solution on already installed files – Nisha Sharma Mar 07 '18 at 04:40

Sunny Kumar · Answer 2 · 2018-06-07T11:47:52.937

For those who are new to laravel and looking for a solution, please follow the steps 1). php artisan make:migration add_title_to_tasks_table --table="tasks"

2). Edit the newly created file in the migrations folder and add the below.

public function up() {
    Schema::table('tasks', function (Blueprint $table) {

        $table->string('title')->after('id');

       // to change column datatype or change it to `nullable` 
       // or set default values , this is just example

       $table->string('title')->default('Test')->change(); 

    });
}

3). Run the migrations command.

php artisan migrate

Thank you! This is what I was looking for. – Aline Matos May 25 '19 at 23:38 — Aline Matos, May 25 '19 at 23:38

score 1 · Answer 3 · answered Mar 06 '18 at 12:09

Do the following:

/**
 * Run the migrations.
 *
 * @return void
 */
public function up()
{
    Schema::table('tasks', function (Blueprint $table) {
       $table->string('title')->after('your-column-name');
    });
}

Replace 'your-column-name' with your existing column name.

Save the file. From terminal, execute:

php artisan migrate

The above command will add the column to your table.

You are getting that error because you are not running the migrate command. Whenever you create a migration file, you must execute the above command in order to see the changes in your database table.

Also, if the new column does not exist in the models $fillable property, you will have to add it there as well..

/**
 * The attributes that are mass assignable.
 *
 * @return  array
 */
protected $fillable = [
    'title', // <-- new column name
    // .. other column names
];

Failing to do update the $fillable property will result in MassAssignmentExecption

Hope this helps you out. Happy Coding. Cheers.

How to add new column to existing table in laravel

3 Answers3