MySQL Auto-increment: Delete Record VS Truncate Table

Показать описание

I thought to demonstrate a thing that some of you may not know, about how exactly auto-increment fields work, in MySQL example. What happens if you delete the record - will the next ID be the same?

- - - - -
Support the channel by checking out my products:

- - - - -
Other places to follow:

Laravel Daily

Рекомендации по теме

Комментарии

Thanks for the great tip in case of MySQL. Just wanted to mention that different dBs might have another syntax, f.ex. _alter sequence {tablename}_id_seq restart with {id}_ in case of PostgreSQL.

ruslanvoroshchukowlookitlt

wished there was a way using artisan for example :D ..
I used to change this manually in PHPmyadmin in : operations > table options > auto increment ..

mibrahim

I belive in using the uuid as primary key as trait. Any Suggestion ?

shaikhdanish

I thought there is an eloquent function that chain with delete() to reset auto increment so as the next record will have the id of deleted record

saydfuad

Why would we truncate instead of delete other than freeing the ID for other records?

PathOfDamn

MySQL Auto-increment: Delete Record VS Truncate Table

MySQL Auto-increment: Delete Record VS Truncate Table

Clear, Reset ID Counter of MySQL Table

SQL Server Tutorial: repair numbering in auto increment field when delete row or rows in SQL server

MySQL : Auto Increment after delete in MySQL

How to set Auto Increment to one 1 even after deleting records in SQL Server

How To Reset MySQL Auto Increment Column - MySQL Developer Tutorial

MySQL: AUTO_INCREMENT is awesome

How AUTO INCREMENT property works in MySQL or MariaDB - MySQL Developer Tutorial

How to set Auto Increment to one 1 even after deleting records. PhpmyAdmin ( Php my admin)

Databases: MySQL auto increment problem with deleting rows / archive table

Reset Auto Increment Column Id MySQL (PHPMyAdmin) Database Table

How To Reset Table Auto Increment Column Id In MySQL (PHPMyAdmin)

How to reset auto increment MySQL

How to reset AUTO INCREMENT value in MySQL

How to drop or disable Auto Increment Property of column in MySQL Table - MySQL Developer Tutorial

PHP My Admin Auto Increment Problem: How to delete a row and stack auto increment in order

How to Reset MySQL Autoincrement

HOW TO DELETE OR TRUNCATE ALL ROWS IN MYSQL AND DELETE A DATABASE 🗑️

MySQL for Beginners 011: Auto Increment

MySQL : Hibernate auto increment sequence is lossing after delete and insert

How to Add Auto Increment Column in Existing Table in MySQL Database in Phpmyadmin

MySQL 15 - Auto Increment (AUTO_INCREMENT)

MySQL Auto-Increment: What Happens After Failed SQL Insert?

MySQL : Auto Increment skipping numbers?