Re: replace/insert into ... 150,000 -plus rows

- 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'll not trust this task to anyone other than myself. Then why

Re: replace/insert into ... 150,000 -plus rows

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

Re: replace/insert into ... 150,000 -plus rows

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? replace

replace/insert into ... 150,000 -plus rows

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 field. I'm presented the task of fixing this data before