Problem in auto_increment

[mostafijur]

Hello,

My database table containing a column name P_ID

Field Extra = P_ID,
Type = int(11),
Null = NO,
Key = PRI,
Default = NULL,
Extra = auto_increment

1. If I delete any row from my table (eg. P_ID = 2) I dont get that P_ID even I insert any new data. Is it for auto_increment?

2. If I want to remove auto_increment from that attribute, how it possible?

Advance thanks.

[mwasif]

1. Whenever you insert a new record, you get an incremented value. This is how auto_increment works.

2. Use the following query to remove auto_increment

ALTER TABLE table_name CHANGE P_ID P_ID INT( 11 ) NOT NULL