Start primary key from a value in Laravel 9

Question

I need to set the value of my primary key to start from 1150, but I can't lose my DB data, I created a new migration and executed the following codes:

    public function up()
    {
        Schema::table('tickets', function (Blueprint $table) {
            $table->id()->startValue(1150)->change();
        });
    }

I tried to run too

    public function up()
    {
        Schema::table('tickets', function (Blueprint $table) {
            $table->id()->from(1150)->change();
        });
    }

Even running these migrations, the table keeps inserting in the default value of ids, 5, 6, 7...

https://stackoverflow.com/questions/34196045/set-auto-increment-field-start-from-1000-in-migration-laravel-5-1 — EHF Shahab, Aug 18 '22 at 17:08

score 0 · Accepted Answer · answered Aug 18 '22 at 17:16

0

Schema::table('tickets', function (Blueprint $table) {
   DB::update("ALTER TABLE tickets AUTO_INCREMENT = 1150;");
});

answered Aug 18 '22 at 17:16

Paul J.K

603
1
4
13

Start primary key from a value in Laravel 9

1 Answers1