Hi,
I'm trying to combine DMOZ data with data already existing in my database, however the dmoz links/categories have the same ID's as the existing links/categories. Is there an easy way to go about combining the two without conflicts?
I have tried this:
UPDATE CatLinks SET LinkID=LinkID+9000;
This successfully updated the ID's so they didn't conflict with the dmoz ID's but when I try:
UPDATE Links SET ID=ID+9000;
and
UPDATE Category SET ID=ID+9000;
...I get the following error:
ERROR 1062: Duplicate entry '9001' for key 1
I know I'm missing something simple but I don't get why it works for CatLinks but not Links and Category. Is this re-numbering even necessary?
Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/
I'm trying to combine DMOZ data with data already existing in my database, however the dmoz links/categories have the same ID's as the existing links/categories. Is there an easy way to go about combining the two without conflicts?
I have tried this:
UPDATE CatLinks SET LinkID=LinkID+9000;
This successfully updated the ID's so they didn't conflict with the dmoz ID's but when I try:
UPDATE Links SET ID=ID+9000;
and
UPDATE Category SET ID=ID+9000;
...I get the following error:
ERROR 1062: Duplicate entry '9001' for key 1
I know I'm missing something simple but I don't get why it works for CatLinks but not Links and Category. Is this re-numbering even necessary?
Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/