You can now easily change the default database auto increment value in Laravel
Published on by Eric L. Barnes
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… pic.twitter.com/Bg24S7iX4j
— Taylor Otwell (@taylorotwell) September 6, 2020
public function up(){ Schema::create('posts', function (Blueprint $table) { $table->id()->startingValue(1200); ...
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.
Eric is the creator of Laravel News and has been covering Laravel since 2012.