eden van onenigheid.
>
> All email sent by me is careware. This means that it can only be reread and
> kept if you are good for all the life here on earth and beyond. If you don't
> agree to these terms, you should return this email in no more than 24 hours
> stating the reason o
[EMAIL PROTECTED] wrote:
>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, w
e here on earth and beyond. If you don't
agree to these terms, you should return this email in no more than 24 hours
stating the reason of disagreement.
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 11 juli 2002 03:28
Aan: [EMAIL PROTECTED]
CC:
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
which
ng writing it
it would just seem wrong to delete it all now
good luck :)
_
daniel a. g. quinn
starving programmer
corporation, n.
an ingenious device for obtaining individual profit without individual
responsibility.
- ambrose bierce
----- Original Message --
Using Linux/Unix I'd say:
echo "SELECT concat('DELETE FROM mailtab WHERE
mailaddress=',mailaddress,';') FROM mailtab WHERE " | mysql | mysql
[EMAIL PROTECTED] wrote:
>I have about 40,000 email addresses in a MySQL database.
>
>I also have a list of 1500 email addresses that need to be remove
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 who
