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

laravelcloud logo
Laravel Cloud

Easily create and manage your servers and deploy your Laravel applications in seconds.

Visit Laravel Cloud

The latest

View all →
Securing Filament plugins with Plumb image

Securing Filament plugins with Plumb

Read article
LayaPHP: Self-Hosted Text Classification for PHP and Laravel image

LayaPHP: Self-Hosted Text Classification for PHP and Laravel

Read article
WhenMounted and BigInt Props in Inertia.js v3.8 image

WhenMounted and BigInt Props in Inertia.js v3.8

Read article
Postcodes for Laravel: GB Postcode Lookup and Geography Data image

Postcodes for Laravel: GB Postcode Lookup and Geography Data

Read article
Laravel 14 Adds a defaults() Method to Eloquent Models image

Laravel 14 Adds a defaults() Method to Eloquent Models

Read article
Laravel AI SDK and Laravel MCP Security Fixes: Update Now image

Laravel AI SDK and Laravel MCP Security Fixes: Update Now

Read article