Elsner �����(�): > At 16:23 05.10.2001, you wrote: > >Add "sum(deleted=0)" to select list of your query. > >Records are not deleted from "urlword" table, but field "deleted" is set to 1. > > > > > >Alexander. > > Thank you, that was very helpful. > > OK, but if I really wish to clean up my database from these entries, > can I do it manually without destroying the integrity of the > database? There might be dangling referrers then ...?
There might be dangling referrers from inverted index if you changed configuration of "index" between sessions. > > > mysql> > use aspseek12; > delete from urlword where deleted=1; > > Or do you suggest to build the database from scratch. > (I now use a robots.txt file to protect the /video/ directory from > indexing.) > > My urlword table: > mysql> show columns from urlword; > +-----------------+--------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-----------------+--------------+------+-----+---------+----------------+ > | url_id | int(11) | | PRI | NULL | auto_increment | > | site_id | int(11) | | | 0 | | > | deleted | tinyint(4) | | | 0 | | > | url | varchar(128) | | UNI | | | > | next_index_time | int(11) | | MUL | 0 | | > | status | int(11) | | | 0 | | > | crc | varchar(32) | | | | | > | last_modified | varchar(32) | | | | | > | etag | varchar(48) | | | | | > | last_index_time | int(11) | | | 0 | | > | referrer | int(11) | | | 0 | | > | tag | int(11) | | | 0 | | > | hops | int(11) | | MUL | 0 | | > | redir | int(11) | YES | | NULL | | > | origin | int(11) | YES | MUL | NULL | | > +-----------------+--------------+------+-----+---------+----------------+ > 15 rows in set (0.03 sec) > > Frank > > #-------------------------------------------------------# > Dipl.-Math. Frank Elsner > Universitaet Osnabrueck (University of Osnabrueck) > - Rechenzentrum - (Computing Center) > Albrechstrasse 28, AVZ > D-49076 Osnabrueck > Deutschland (Germany) > > Tel. (Phone): ++49 (0)541/969-2343 Fax: -2470 > E-Mail: [EMAIL PROTECTED] > #-------------------------------------------------------#
