It's all better now
I dug out the old MySQL book and figured out how to delete the duplicates.
Basically I exported lsql_CatLinks into a temporary table and used the DISTINCT parameter.
SELECT DISTINCT lsql_CatLinks.LinkID, lsql_CatLinks.CategoryID
FROM lsql_CatLinks;
Then I renamed lsql_CatLinks to lsql_CatLinksOriginal and renamed lsql_CatLinksTemp to lsql_CatLinks
Worked like a charm
Andy, thank you for your assistance.
Jack R.
http://www.aeroseek.com/
I dug out the old MySQL book and figured out how to delete the duplicates.
Basically I exported lsql_CatLinks into a temporary table and used the DISTINCT parameter.
Code:
mysql> CREATE TABLE lsql_CatLinksTemp SELECT DISTINCT lsql_CatLinks.LinkID, lsql_CatLinks.CategoryID
FROM lsql_CatLinks;
Then I renamed lsql_CatLinks to lsql_CatLinksOriginal and renamed lsql_CatLinksTemp to lsql_CatLinks
Worked like a charm
Andy, thank you for your assistance.
Jack R.
http://www.aeroseek.com/