Dont know why I named the question Table's.. o well
So I am creating a database for my class, it is rather basic. It includes a INT, a TEXT, and a DATE ie.
1 xxxxxx 2011-4-4
2 xxxxxx 2011-4-4
My question is, when I delete both lines in the DB, why does the DB not backtrack to a empty INT (which should be 1), yet it moves onto 3. Is it b/c of the auto_increment that I added? Or do I have tell it to look for the next vacant INT and then go from there.. Note: I am a beginner, so I am just curious.