Re: multiple deleting and updating (addnew)
| From: | Tatang Widyanto | Date: | Tue, 04 Jan 2005 03:05:00 +0000 |
| Subject: | Re: multiple deleting and updating (addnew) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-205563@lists.php.net to get a copy of this message | ||
DELETE FROM TableName
WHERE UserID IN ('User1', 'User2', '', ..)
UPDATE TableName
SET fieldName='NewValue'
WHERE UserID IN ('User1', 'User2', '', ..)
Sejati Opreker wrote:
Hi all, I meet a problem when I want to deleting a multiple row, I have a table that contain columns UserID, name, company name, and bill. UserID is uniq. perhaps, some of UserID, say it five UserID I have to delete, how to delete all raw that contain that UserID ? and if I want to update bill of a users (multiple user) that data of users taking from a file ( so the file contain user UserId and bill), how to make it ? Thanks, Aji __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com