Re: Multiplle update by key

2001-06-30 Thread Rolf Hopkins
ne 29, 2001 21:41 Subject: Multiplle update by key > I have a table with an autoincrement primary key, and a I hold list of the > keys of a number of records which I want to UPDATE. How can I most > efficiently write an UPDATE command which will update all the record whose > keys ar

Multiplle update by key

2001-06-29 Thread alec . cawley
I have a table with an autoincrement primary key, and a I hold list of the keys of a number of records which I want to UPDATE. How can I most efficiently write an UPDATE command which will update all the record whose keys are on my list? I thought I could put the keys I have into a temporary ram