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 ...? 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] #-------------------------------------------------------#
