MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: update with if statement
Posted by: Steve Szmidt
Date: July 04, 2005 09:09AM

Shantanu Oak wrote:
> update cdr set
> Cost=if(mod(BillSec,6)=0,floor(BillSec/6),ceiling(
> BillSec/6))

Looks like I'm the fool!

To me it obviously did not look right but more like a stock function. Once I tried your sample it worked!

Thanks!

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


Subject
Written By
Posted
update with if statement
Steve Szmidt
July 03, 2005 11:27PM
Re: update with if statement
Shantanu Oak
July 04, 2005 02:13AM
Re: update with if statement
Steve Szmidt
July 04, 2005 06:43AM
Re: update with if statement
Steve Szmidt
July 04, 2005 09:09AM
Re: update with if statement
Steve Szmidt
July 04, 2005 08:26AM
Re: update with if statement
Steve Szmidt
July 04, 2005 08:35AM


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.