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
Anyone care to tell me what I'm doing wrong?
probably forgot to declare a primary or unique key
rudy
http://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
And THAT... is why they pay Rudy the big bucks..
It was an index, not unique..
Cheers!!!
On 27/02/07, r937 [EMAIL PROTECTED] wrote:
Anyone care to tell me what I'm doing wrong?
probably forgot to declare a primary or unique key
rudy
http://r937.com/
• The WDVL Discussion List from
And THAT... is why they pay Rudy the big bucks..
not on this discussion list they don't
;o)
� 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/
So you admit they do elsewhere? grin
Peter MacGregor
At 15:26 27/02/2007, you wrote:
And THAT... is why they pay Rudy the big bucks..
not on this discussion list they don't
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:[EMAIL
So you admit they do elsewhere? grin
not at all, sir
it is entirely plausible that they don't on any discussion list
but my statement is still correct -- not on this list they don't
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL
I wasn't referring to lists - but to
clients/employers etc - those nuisances none of us can live with or without!
Peter
At 16:42 27/02/2007, you wrote:
So you admit they do elsewhere? grin
not at all, sir
it is entirely plausible that they don't on any discussion list
but my statement is