You probably should specify the fields for the insert. MySQL is probably inserting into the ID field because you didn't specify
which fields to use for inclusion.
INSERT INTO jobs (field1,field2,...) (SELECT...)
- Original Message -
From: John Kopanas [EMAIL PROTECTED]
To: [EMAIL
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:
Wow, I am a little tired... this is the query causing me the problem...
INSERT INTO jobs
(SELECT * FROM tmpJobs WHERE NOT EXISTS
(SELECT * FROM jobs WHERE jobs.customer_number =
tmpJobs.customer_number and jobs.job_number = tmpJobs.job_number));
Why is the id not creating distinct #s?
On
