2) Also, is it possible that if an ID has been deleted that the auto-increment re-uses it on the next insert?
I want to avoid having this (notice id 3 is missing and it continued with 4 instead of 3):
id - col1 - col 2
1 - blah - cdata
2 - blah - ddata
4 - blah - data