MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: set a column in dependency of two others
Posted by: Michael Stahl
Date: January 20, 2015 03:50AM

I solved this with a second SQL statemant where I used a IF function.

UPDATE table SET C=IF(A='1' AND B='1'),1,0) WHERE ID='11'

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
set a column in dependency of two others
Michael Stahl
January 20, 2015 03:15AM
Re: set a column in dependency of two others
Michael Stahl
January 20, 2015 03:50AM
Re: set a column in dependency of two others
Peter Brawley
January 20, 2015 11:41AM


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.