How to reset the autoincrement max value when running migrations in Laravel

Question

I'm new to Laravel and I have this table migration working fine

public function up()
{
    Schema::create('tenants', function (Blueprint $table) {
        $table->integer('tenant_id')->autoIncrement();
        $table->string('name', 45);
        $table->integer('plan_id')->nullable();
        $table->integer('status')->nullable();
    });
}

public function down()
{
    Schema::dropIfExists('tenants');
}

If i run php artisan migrate: fresh the auto increment max value is not set back to 1.

I know how to do it in SQL but I want to use Laravel options.

Thank you

Is there a reason you’re not using the default ID column and type? — Peppermintology, Oct 22 '22 at 06:49
Does this answer your question - [https://stackoverflow.com/a/34196202/19432371](https://stackoverflow.com/a/34196202/19432371) — discussion, Oct 22 '22 at 08:20

MOHIN SANDHI · Answer 1 · 2022-10-22T07:12:37.800

1)we can use from method to set autoincrement start value
$table->integer('tenant_id')->from(number);

2)this will other method to change autoincrement value 
public function up()
{
    Schema::create('tenants', function (Blueprint $table) {
        $table->integer('tenant_id')->autoIncrement();
        $table->string('name', 45);
        $table->integer('plan_id')->nullable();
        $table->integer('status')->nullable();
    });
    \DB::statement('ALTER TABLE tenants AUTO_INCREMENT = 1000;');
}

How to reset the autoincrement max value when running migrations in Laravel

1 Answers1