Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

How to remove all data once?

Quote Reply
How to remove all data once?
Hi,
In SQL Monitor, how to set the categories data be blank? because while I import the categories table, I find that it accumulate the existing categories.
Quote Reply
Re: How to remove all data once? In reply to
Just enter:

DELETE FROM Category

into the monitor.

Cheers,

Alex
Quote Reply
Re: How to remove all data once? In reply to
Hello!
#

One of the best programs I can recommend you id phpMyAdmin. This you can download it from www.phpwizard.net

Its free and its also bugs free Smile

In the main table of the database you will find all the listing of the functions and one of them is empty table. With a click you can empty any table without having to get into learning MySQL commands of any type. For special work on the database editor.cgi by Alex is extremly good. However the features are not enough but I am sure they will come.

------------------
rajani