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