Tuesday 15 March 2011

sql - MySQL - Error Code: 1062. Duplicate entry 'PRIMARY' even no duplicate records -



sql - MySQL - Error Code: 1062. Duplicate entry 'PRIMARY' even no duplicate records -

my table (fs_db.parentlist) contains 2 keys (pid, mid). sql codes here:

delete fs_db.parentlist pid = 36479 or mid = 36479; delete fs_db.parentlist pid = 36481 or mid = 36481; select * fs_db.parentlist pid = 36479 or mid = 36479; select * fs_db.parentlist pid = 36481 or mid= 36481; insert fs_db.parentlist (pid, mid) values (36479,36481);

as see have deleted records before inserting, , select statement returns 0 rows. when run insert statement, returns:

error code: 1062. duplicate entry '36479' key 'primary'

could 1 provide helps?

thank you.

mysql sql

No comments:

Post a Comment