Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to to combine 2 databases of business listings (table rows) into one database. All the listings (rows) are unique but the problem is that some of them have same database ids. So when try to import the second database, it gives me an error:

1062 - Duplicate entry '1' for key 'PRIMARY' .

How can I solve that problem? Maybe to make an SQL query to remove the ids of the second database so the rows will get new ids when imported.

Sorry if my question looks stupid, but I'm not a coder :)

share|improve this question
 
Welcome to StackOverflow. Please at least take the time to proofread your question before posting. "How ot import slq data" leaves a very poor impression - if you can't put forth the effort to even ask a readable question, why should we put forth the effort to answer it? And "2ond" and "whne" - the first isn't even an actual word. –  Ken White 6 mins ago

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.