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:
DELETE FROM PersonalDetails WHERE UserID = id;
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.