Hello,

When Alex first installed Links SQL on my web site he imported the existing links into the SQL database. I used import.pl to import the new links, but it seems that it just added all of them, instead of overwriting them. How do I delete every link on the system so that I can run Import.pl from scratch?

------------------
James L. Murray
VirtueTech, Inc.
www.virtuetech.com

To clear all your data on the Links Table the command is:

DELETE FROM Links

Also if you want to clear Categories you will need to do this one also:

DELETE FROM Category

Now to use that all you have to do is go to the appropriate listing under table maintenance and then on the page click SQL Monitor.

Steve

Hello,

I enetered:
DELETE FROM Links

In the SQL Monitor and it did not work.

It said that 0 Rows were affected.

------------------
James L. Murray
VirtueTech, Inc.
www.virtuetech.com

That's normal. Mysql does not report the actual number of rows deleted when you do delete from links. They should all still be gone though.

Cheers,

Alex