Morning all..!
i'm importing data from a csv file.
No worries, but oneof the fields I wanna import is an email address..
BUT, if the address already exists, I don't wanna bother.
To that end, I made the email column my index for the table, and used:
REPLACE INTO imported_newAffiliates (`emailAddress`, `signUpDate`)
VALUES('[EMAIL PROTECTED]', '2007-01-14 11:42:24')
and yet it's still duplicating the data
Duplicates are unlikley, but I'd like to be safe...
Anyone care to tell me what I'm doing wrong?
Tris...
--
When a person can no longer laugh at himself, it is time for others to
laugh at him.
Thomas Szasz
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
