How to let ID autoincrement start from certain number in Laravel Migration

Question

I want to write a Laravel Migration auto increment ID as a primary key. I want to start this ID with a another value rather than 1. How can I do so ?

The migration up() function:

public function up()
{
    Schema::create('users', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name');
        $table->string('email')->unique();
        $table->string('phone');
        $table->rememberToken();
        $table->timestamps();
    });
}

I don't think there's an elegant way to do this. You'll probably need to run a raw db statement via `DB::statement(..)` and use one of the solutions at https://stackoverflow.com/questions/1485668/how-to-set-initial-value-and-auto-increment-in-mysql — apokryfos, Feb 03 '20 at 14:46

score 10 · Answer 1 · answered Jan 11 '21 at 08:10

10

As of Laravel 8.x, you can now use this in your migration:

public function up()
{
    Schema::create('posts', function (Blueprint $table) {
        $table->id()->startingValue(1200);
    });
}

Source: https://laravel-news.com/laravel-auto-increment

answered Jan 11 '21 at 08:10

Brent Arcane

163
2
8

score 2 · Answer 2 · answered Feb 03 '20 at 14:57

You can use 2 methods

By Statement DB::statement("ALTER TABLE your_table_here SET AUTO_INCREMENT = 9999;");

By inserting row and deleteing it.

DB::table('your_table_here ')->insert(['id' => 99999, ... ,'column' => 'value']);
DB::table('your_table_here ')->where('id', 99999)->delete();

Hope this helps

score 1 · Answer 3 · answered Jan 30 '21 at 18:24

If you want your first ID in the table to be for example 10001.

If you are using Laravel 8.x

public function up()
{
    Schema::create('users', function (Blueprint $table) {
        $table->bigIncrements('id')->from(10001);
        .
        .
        $table->timestamps();
    });
}

score 0 · Accepted Answer · edited Feb 04 '20 at 02:02

0

add a record with id (desired id -1) and then delete it.

If you add a record with id 999, and then delete it, next record will have id 1000. You can also use SQL identity on your database

edited Feb 04 '20 at 02:02

Yomna Hesham

462
3
16

answered Feb 03 '20 at 14:49

Filip

79
6

so what will be the initial value ? – Yomna Hesham Feb 03 '20 at 14:52
1

if you add a record with id 999, and then delete it, next record will have id 1000. You can also use SQL identity on your database. – Filip Feb 03 '20 at 15:06
this is not good way. – nafischonchol Jul 24 '23 at 10:14

score 0 · Answer 5 · answered Feb 04 '20 at 06:19

0

After Creating Migrations Just Go to your Mysql Database and put this query

ALTER TABLE users AUTO_INCREMENT = 1000;

answered Feb 04 '20 at 06:19

Naeem Ijaz

805
9
17

score -3 · Answer 6 · answered Feb 03 '20 at 14:59

-3

try this ?

$table->increments('id')->start_from(10000);

answered Feb 03 '20 at 14:59

feivorid

1
2

1

that method doesn't exist, not even in Version 6.0 https://laraveldaily.com/set-auto-increment-start-laravel-migrations/ – Edwin Krause Feb 03 '20 at 15:05

How to let ID autoincrement start from certain number in Laravel Migration

6 Answers6