delete record problem

[Bee]

Hi,

when my command deletes a record. All columns are deleted perfectly, but the primary key is set to 0 instead of being deleted and that causes a lot of gaps in the table.

I am using a command like this:
[code]
DELETE FROM PersonalDetails WHERE UserID = id;
[/code]

When I use the same command on mysql console, it works perfectly! But it doesn't work as good from my application.


Is there any way I can delete it totally?

Any help will be very much appreciated.

Bee

[fenway]

Say what? Unless you're using InnoDB tables, UIDs for AUTO_INCREMENT columns are not re-used unless you explicitly specify a UID to use or reset the increment counter meta-variable. Of course, I've said it once, and I'll say it again: "gaps in the table" doesn't make a lick of difference to anyone. Leave it be.

BTW, I have no idea what you are describing from the console.