Hello,
I have the fullowing sql db sheme and like to del
an email. What do I need to del from each db?
Thanks,
Alex
mysql> describe
bayes_expire;
+---------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+-------+ | id | int(11) | | MUL | 0 | | | runtime | int(11) | | | 0 | | +---------+---------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> describe
bayes_global_vars;
+----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | variable | varchar(30) | | PRI | | | | value | varchar(200) | | | | | +----------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> describe
bayes_seen;
+-------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+-------+ | id | int(11) | | PRI | 0 | | | msgid | varchar(200) binary | | PRI | | | | flag | char(1) | | | | | +-------+---------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> describe
bayes_token;
+------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------+------+-----+---------+-------+ | id | int(11) | | PRI | 0 | | | token | char(5) | | PRI | | | | spam_count | int(11) | | | 0 | | | ham_count | int(11) | | | 0 | | | atime | int(11) | | | 0 | | +------------+---------+------+-----+---------+-------+ 5 rows in set (0.00 sec) mysql> describe
bayes_vars;
+--------------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | username | varchar(200) | | UNI | | | | spam_count | int(11) | | | 0 | | | ham_count | int(11) | | | 0 | | | token_count | int(11) | | | 0 | | | last_expire | int(11) | | | 0 | | | last_atime_delta | int(11) | | | 0 | | | last_expire_reduce | int(11) | | | 0 | | | oldest_token_age | int(11) | | | 2147483647 | | | newest_token_age | int(11) | | | 0 | | +--------------------+--------------+------+-----+------------+----------------+ 10 rows in set (0.00 sec) |
- Re: Delete email and all settings from bayes sql db Alexander Newald
- Re: Delete email and all settings from bayes sql db Michael Parker
- Re: Delete email and all settings from bayes sql... Alexander Newald
- Re: Delete email and all settings from bayes... Michael Parker