How to make id start with Nth number in MySQL database in Laravel?

Question

MySQL

How to specify $table->bigIncrements('id');start id from 100001, for example

Answer 1

//Your migrations here:
Schema::create('users', function (Blueprint $table) {
    $table->bigIncrements('id')->unsigned();
    $table->integer('qualification_id')->nullable();
    $table->integer('experience_id')->nullable();
});

//then set autoincrement to 1000
//after creating the table
DB::update("ALTER TABLE users AUTO_INCREMENT = 1000;");

https://stackoverflow.com/a/34196202/2981702