[FIXED] How to set AUTO_INCREMENT in Laravel with Eloquent?

Issue

I am working on an application and my employer wants that the id in the user table should begin from 100,000 instead of 1. How can accomplish that? Is it a parameter in the Schema Builder itself? Or would I have to set something in the MySQL instead?

Solution

You can use SQL its self to do this. ALTER TABLE <table_name> AUTO_INCREMENT=100000;.

Or

Do it like here

And use a unprepared statement;

$statement = "ALTER TABLE MY_TABLE AUTO_INCREMENT = 100000;";

DB::unprepared($statement);

or

DB::update("ALTER TABLE {your table name} AUTO_INCREMENT = 100000;");

Which could then be put within the migration that creates the table.

Answered By - Matt Burrow