Jump to content

same id inserting again in a table?


rashgang

Recommended Posts

i have created a table in mysql with primary and auto increment

 

example:

create table sample(id int not null primary key,first_name varchar(30))

 

insert into table sample values(1,'test');

insert into table sample values(2,'test');

 

after delete the first row with id "1". then insert again 1 on the same table it gets inserted

my question we have created the table with primary key how the same id inserted again?

 

Link to comment
https://forums.phpfreaks.com/topic/277150-same-id-inserting-again-in-a-table/
Share on other sites

Because you deleted the old record and you specifically told MySQL to use id=1 again. If you had an auto_increment column (like your example does not show) and you didn't specify the new id value, MySQL would have used id=3.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.