- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Network" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 3:08 AM
Subject: Re: replace/insert into ... 150,000 -plus rows
>
> > I
>
> Besides that theoretical stuff, though, the real problem is that
> INSERT is for inserting new records into a database table. What
> you're trying to do is UPDATE existing records with new data. And
> there's no INSERT ... SELECT counterpart in the UPDATE syntax.
What about replace?
repla
On Mon, Aug 20, 2001 at 11:38:57PM -0400, Network wrote:
> The problem= The 'addy1' column or field (in attdata) is tainted
> with incorrect data entries ... e.g. 'addy1' should only have
> addresses stored however, some bright person(s) have managed to
> input company names in the address/addy1
