What happens if a row is deleted and another inserted. Will the auto-increment fill the cap or not? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

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

sqltables
5th Jul 2016, 6:31 PM
Philipp Thalhammer
5 Answers
+ 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

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Please help, have been getting error message since past 3 days now. can't pass this level even when the answer is right.
1 Votes
How to access caller class attribute
0 Votes
Media on HTML
0 Votes
How do people have HTML course but i dont
1 Votes
Code Playground
0 Votes
Is Sololearn better or Mimo.org?
1 Votes
xampp
0 Votes
Editor HTML
0 Votes
How to solve this
1 Votes
Java project
0 Votes