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

P: 160
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
Error is:
Expand|Select|Wrap|Line Numbers
  1. Error Code : 1062
  2. Duplicate entry '1450011-DE' for key 1
Further explanation is:
when i put this query
Expand|Select|Wrap|Line Numbers
  1. select * from table2 where category_id =1450011
Results are
Expand|Select|Wrap|Line Numbers
  1. "1450011" "FR" "Pierre ponce"
  2. "1450011" "EN" "Pumice"
  3. "1450011" "IS" "Vikur"
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

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
Feb 22 '11 #2

Post your reply

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