update multiple fields
Posted by:
nospam4me
Date: August 18, 2005 04:47AM
I need to update some 900,000 records, each different. I will be pasting the code into the sql window of PHPMyAdmin at my web site. The individual updates look like this:
UPDATE table SET Field1='sample', Field2='sample1' WHERE UniqueID=12345
UPDATE table SET Field1='sample2', Field2='sample3', Field3='yes' WHERE UniqueID=2021432
How can I string together a bunch of these where the SET field values are always different and there is one each for 900,000 different ID's. Right now, I have these in 30 text files but I can't seem to get the syntax correct.
Sheryl
Subject
Written By
Posted
update multiple fields
August 18, 2005 04:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.