MySQL Forums
Forum List  »  Recovering from Crashes

I need update query for this
Posted by: Arul M
Date: December 27, 2005 07:52AM

Hai,

i have to update the table product .

product table contains three fields (i.e.)id,product name and status field.

id productname status
1 software active
2 hardware de-active
3 os de-active
4 package active

i want to upadte the status active to inactive and inactive to active in one update query.

Dont use any like if and other .

is there any possible query is having means reply to me

Thanks,
arul



Edited 1 time(s). Last edit at 12/27/2005 07:55AM by Arul M.

Options: ReplyQuote


Subject
Views
Written By
Posted
I need update query for this
4091
December 27, 2005 07:52AM
2408
December 27, 2005 06:42PM


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.