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