id INT PRIMARY question
Posted: Wed Jun 01, 2005 2:06 pm
This post, originally posted in PHP code is more appropriate here.
Is there a way to delete a particular primary key in the middle of a table then re-sort them so that there are no gaps between numbers?
I'm not exactly sure when to use id INT. On what kind of data would one need such an index, and on what kind of data could one neglect its use?
Is it easier to delete rows (without making as many mistakes such as deleting the wrong row) with the use of this index?
Is there a way to delete a particular primary key in the middle of a table then re-sort them so that there are no gaps between numbers?
I'm not exactly sure when to use id INT. On what kind of data would one need such an index, and on what kind of data could one neglect its use?
Is it easier to delete rows (without making as many mistakes such as deleting the wrong row) with the use of this index?