Resolved: It doesnt allow duplicate entry.
in SQL / Duplicate Records
It doesnt allow me to enter duplicate entry. In one table it allowed, but in other it did not. Why?
2 answers ( 1 marked as helpful)
solved it using
alter table Table_name
drop index column_name;
My table had unique key index.
Thanks for reaching out.
Yes, dropping the unique index solves similar issues.
I am glad that you have resolved your issue!
Submit an answer
INNER JOIN - I cant find the d dept_manger_dup table doesnt exisit. Where did i miss it?