- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 18, 2006 6:28 PM
Subject: Update Multiple Records
Hi folks.
I want to set the status of 5 records to 'completed'. how do I go about
that without having to prepare 5 different instructions?
"update m
update myTable set status = 'completed' where id IN (10,20,30,40,50) LIMIT
5;
I believe that should work.
As a precaution, I recommend always using "LIMIT x" whenever possible on
SELECT, UPDATE or DELETE statements. This will minimize any accidental
dammage to other records should you have misty
