By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,360 Members | 3,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,360 IT Pros & Developers. It's quick & easy.

Getting duplicate entry error even by using IGNORE

100+
P: 160
Hi
I am facing a strange problem. I have a duplicate entry message even though i am using IGNORE in query. My query is
Expand|Select|Wrap|Line Numbers
  1. insert ignore into table1 select * from table2
  2.  
Error is:
Expand|Select|Wrap|Line Numbers
  1. Error Code : 1062
  2. Duplicate entry '1450011-DE' for key 1
  3.  
Further explanation is:
when i put this query
Expand|Select|Wrap|Line Numbers
  1. select * from table2 where category_id =1450011
  2.  
Results are
Expand|Select|Wrap|Line Numbers
  1. "1450011" "FR" "Pierre ponce"
  2. "1450011" "EN" "Pumice"
  3. "1450011" "IS" "Vikur"
  4.  
As you can see there is no DE record for 1450011
And this is the record that stop it
"1450011" "DE" "Bims"
Feb 22 '11 #1
Share this Question
Share on Google+
1 Reply


100+
P: 160
Found the reason!!!
the records did exist for some reason in category__full and by deleting them from there all data where read in
Thanks
Feb 22 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.