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?
id INT PRIMARY KEY question
Moderator: General Moderators
-
jaymoore_299
- Forum Contributor
- Posts: 128
- Joined: Wed May 11, 2005 6:40 pm
- Contact: