Thank-you Chuck, Ralf, Phil, Daniel, and Wouter. All your great advice worked,
and helped me device a method of attack. What I eventually did was edit the text
file itself, with vi, to add delete from churchmail where email = ' to the
start of each line, and to add '; to the end of each line,
I have about 40,000 email addresses in a MySQL database.
I also have a list of 1500 email addresses that need to be removed.
I am searching for a way to delete these 1500 email addresses en masse,
but I have come up short.
I sure would appreciate a nudge in the right direction from somebody
Not surprisingly, I'm still confused. Could you hold my hand?
Here's what I've got --
This is my table --
CREATE TABLE churchmail (
email varchar(30) NOT NULL
);
It has one field containing 40,000 email addresses.
I have a text file -- remove.txt, which contains 1,500 email addresses
I have five tables. Each has a primary key on the field Number.
I would like to determine how many tables -- just the count -- that any
given $Number populates.
Every $Number will populate at least two tables, some possibly all five.
I just want a count(*)
I appreciate the advice.
Robert
I know Sasha has been involved with the email police for awhile. I gotta
tell ya, my opinion is negative. Sure, I understand the dynamics.
Unwanted emails are intrusive. They waste bandwidth. They squander
resources. Those type arguments, however, do not justify the intrusion
the security squad