MiCR0 Posted July 19, 2010 Share Posted July 19, 2010 I am trying to work out a Discount system maths logic for an MYSQL statment, and I can not get my head into Gear so any help would be great. I am working on a system where the user inputs 20% or -20% and then it querys 35,000 products and updates them with the new price now becuase the records are so big I have a problem so its a one statment job. (cost * 0.20) adds on 20% Update products SET cost = (cost* 0.20) WHERE bradletter='A'; // adds 20% to the price I think the above is correct how would you remove 20%? thanks MiCR0 Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted July 19, 2010 Share Posted July 19, 2010 Add 1%: new = original * (1 + 0.01) = original * 1.01 Subtract 1%: new = original * (1 - 0.01) = original * 0.99 Quote Link to comment Share on other sites More sharing options...
MiCR0 Posted July 20, 2010 Author Share Posted July 20, 2010 Your a Star Daniel Thank you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.