primary key - Duplicate entry mysql -



primary key - Duplicate entry mysql -

i have table has not have primary key.table has indexes. whenever seek insert record first time ,record gets inserted when seek insert record same value 1 time again gives duplicate entry '125249-1'. create table :-

create table `schedules` ( `entity` bigint(20) default null, `id` bigint(20) default null, `applicationid` int(16) default null, `apptnid` int(16) default null, `apptorgunitid` bigint(20) default null, `orgid` int(16) default null, `nid` int(16) default null, `logged_date` datetime default null, `logged_by` int(16) default null, `last_updated_date` datetime default null, `last_updated_by` int(16) default null, `rowstate` int(8) default '1', `status` int(16) default '1', key `applicationid` (`applicationid`), key `apptnid` (`apptnid`), key `id` (`id`) ) engine=innodb default charset=latin1; insert schedules (entity, id, applicationid, apptnid, apptorgunitid, orgid, nid, logged_date, logged_by, rowstate, status) values (125249,454,85246,2,2,124,1,current_timestamp,9999,1,1) error : - duplicate entry '125249-1' key 'primary'

mysql primary-key duplicates

Comments

Popular posts from this blog

maven fortify plugin : Unable to load build session with ID XXXXX .. See log file for more details -

c# - Primavera WebServices does not return any data -

android - Display emoji panel with genymotion - keyboard/touch input? -