News

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

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

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 L. Barnes photo

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

Sponsored

acquaintsoft logo
Acquaint Softtech

Hire Laravel developers with AI expertise at $20/hr. Get started in 48 hours.

Visit Acquaint Softtech

The latest

View all →
Volker Dusch on the PHP RCE Vulnerabilities and Disclosure image

Volker Dusch on the PHP RCE Vulnerabilities and Disclosure

Read article
Decide with Jev: Turn AI Answers into Decisions with PHP Rules image

Decide with Jev: Turn AI Answers into Decisions with PHP Rules

Read article
Skuul: Open-Source School Management Built on Laravel image

Skuul: Open-Source School Management Built on Laravel

Read article
Laravel Read Replicas: Prevent Stale Reads After a Write image

Laravel Read Replicas: Prevent Stale Reads After a Write

Read article
Screenshot: Capture Images and PDFs with PHP and Laravel image

Screenshot: Capture Images and PDFs with PHP and Laravel

Read article
Reset Sticky Database Connections Between Laravel Queue Jobs image

Reset Sticky Database Connections Between Laravel Queue Jobs

Read article