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 need to be removed from the churchmail table. The database is
named midtn. I think it's the two WHERE clauses that are throwing me.
Whatever it is, I remain stuck, and would appreciate assistance. I'd
like to do this on the command line, no PHP.
Thanks,
Robert
Ralf Narozny wrote:
> Using Linux/Unix I'd say:
>
> echo "SELECT concat('DELETE FROM mailtab WHERE
> mailaddress=',mailaddress,';') FROM mailtab WHERE <some strange
> conditions here>" | mysql <db> | mysql <db>
>
> [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 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
> >might be in the know.
> >
> >
> >
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
