You can now easily change the default database auto increment value in Laravel


September 7th, 2020


Laravel 8 adds a brand new method to make changing the auto-increment starting value easy, and here is the official announcement made on Twitter:

Sneaking this into Laravel 8.x today…

— Taylor Otwell (@taylorotwell) September 6, 2020

1public function up()
3 Schema::create('posts', function (Blueprint $table) {
4 $table->id()->startingValue(1200);
5 ...

Changing the auto-increment through the various database platforms has always been possible, but you needed to do it via a raw command. With the addition of the startingValue method, this allows you to set the first number the auto-increment will start at in a fluent Laravel way.

For most apps, you will probably not need this but in those situations where you do not want a record starting at one, it’s a handy option.

Filed in:

Eric L. Barnes

Eric is the creator of Laravel News and has been covering Laravel since 2012.

Laravel News Partners