0

What happens if a row is deleted and another inserted. Will the auto-increment fill the cap or not?

5th Jul 2016, 6:31 PM
Philipp Thalhammer
5 Respostas
+ 1
no it will not fill the gap...
6th Jul 2016, 10:49 AM
Ashutosh Singh
0
Auto_Incerment will not filled the gap.
7th Jul 2016, 1:24 AM
Dipankar Banik
Dipankar Banik - avatar
0
no
8th Jul 2016, 7:57 AM
niki
0
maybe
8th Jul 2016, 4:58 PM
liu
0
No it does not adjust. But u can reset auto increment counter using ALTER TABLE statement.
4th Sep 2016, 8:01 AM
Nagarajan Chinnasamy
Nagarajan Chinnasamy - avatar