Make column auto incrementable with Laravel Migration

Question

In laravel 5.2 is possible to modify a column to make it auto_increment? I have an ID column, its primary already, but it's not auto_increment, and I need to make it, how can I do it? I have registers in the table (each of them have the corresponding ID) so I cannot delete the registers.

You can always `DB::raw()` http://stackoverflow.com/questions/5035836/how-to-add-auto-increment-to-an-existing-column — Jeremy Harris, Jan 31 '17 at 21:33

Erik Berkun-Drevnig · Accepted Answer · 2017-02-02T21:49:42.873

3

Did you try the change method?

Schema::table('posts', function (Blueprint $table) {
    $table->increments('id')->change();
});

See the documentation section on changing columns for more info.

edited Feb 02 '17 at 21:49

answered Jan 31 '17 at 21:53

Erik Berkun-Drevnig

2,306
23
38

that is trying to add another id column, so it gives error – Sredny M Casanova Jan 31 '17 at 22:32
Updated my answer. What about with the `change` method? – Erik Berkun-Drevnig Feb 02 '17 at 21:50

score 0 · Answer 2 · answered Feb 01 '17 at 03:45

0

Before modifying a column, be sure to add the doctrine/dbal dependency to your composer.json file. Here is the documentation

 Schema::table('users', function ($table) {
        $table->bigIncrements('id');
    });

answered Feb 01 '17 at 03:45

Sanzeeb Aryal

4,358
3
20
43

Make column auto incrementable with Laravel Migration

2 Answers2