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 4/12/07, John Kopanas <[EMAIL PROTECTED]> wrote:
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 :-). Thanks John -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info
-- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]