I have the following query:
INSERT INTO summaries (entity_name, job_type, job_status)
(SELECT entity_name, "GOV", "Non-Workable" FROM tmpSummaryTable);
The only other column I have is id and it is primary key autonumber int.
Why would I get the following error?
ERROR 1062 (23000) at line 3: Duplicate entry '5' for key 1
Why is the query trying to enter a duplicate entry?
This makes no sense to me :-).