Level 70
@alipadida95 Probably you can do this.
$id=DB::select("SHOW TABLE STATUS LIKE 'Your table name'");
$next_id=$id[0]->Auto_increment;
echo $next_id;
8 likes
Dec 23, 2020
12
Level 1
How to get the next autoincrement id
Hi, I am trying to get the next autoincrement id of a table in laravel. i.g. current value of auto-increment id is 4. So the next will 5, right? Can I somehow get the next autoincrment id?
Level 5
for me is not working in laravel 9
$productsInfo = DB::select("SHOW TABLE STATUS LIKE 'products'");
$nextID = $productsInfo[0]->Auto_increment;
the nextID is the last id (not the next)
any idea why? In older version worked....
2 likes
Level 31
@calin.ionut Yes I agree doesn't seem to work with my current stack too. However this works for me:
$nextTransactionId = Transaction::orderBy('id','desc')->first()->id + 1;
3 likes
Level 122
@eugenevdm don't do it. its bad practice
4 likes
Level 31
@Snapey care to elaborate?
2 likes
Level 102
@eugenevdm I am mostly curious how getting the next ID is useful at all. Chances are that the ID is taken by another user, by the time the page is stored
The reason it is problematic is this. Lets say it returns 45. But what you don't know is that there was a 46 earlier that was deleted. So you tell the system that the next id will be 46, when in reality it will be 47
3 likes
Level 122
-
if you have more than one user what you think is the next number can be taken immediately after you read it and before you use it. Two users end up with the same number
-
if you use a transaction, and it fails and gets rolled back, there will be a gap in the numbers
-
the issue that @sinnbeck mentioned
-
Its a code smell. if you think you need to do this then something is wrong with your logic that can be fixed some other way
6 likes
Level 5
it seems that this property has changed to 86400 (24 hours) in Mysql 8.x
SET PERSIST information_schema_stats_expiry = 0
do the job.
Anyone know another better solution to get the next id ???
1 like
Level 122
Don't do it. Its invalid as soon as you have fetched it.
There is absolutely no valid reason to get an autoincrement value ahead of writing a record.
2 likes
Level 1
@Snapey I actually have a case for this, I need to import data from another system with different ID, I need to know the new ID so I can have a mapping between the two system, and use the new ID to import all related data.
1 like
Level 122
@longway you don't need to know it beforehand? Write the main record, get its id and then write the related records
1 like
Level 1
Hi everyone) I have an ideea. You can use uuid, but for this, you need to change primary id in your table. In your migration you need to change $table->id(); to $table->uuid('id')->primary(); In your model you need to add use HasUuids; (use Illuminate\Database\Eloquent\Concerns\HasUuids;)
And then, you can generate uuid before save data.
P.S. It is my first message on Laracast :)
Please or to participate in this conversation.