title: Python: mysql double and float
body: <p>In MySQL table column <strong>balance</strong> has a type DOUBLE without specifying precision. And I can't change column type to DECIMAL or DOUBLE with precision (I know that is epic fail to store money in DOUBLE column, but can't to change something)</p>
  
  <p>If in Python I need to update a balance column, e.g. increase this value (<code>balance = balance + 10/29</code>), should I simply add that Python's float value, or I need to add <code>balance = Decimal(balance) + Decimal(10/29)</code> to avoid loss in accuracy? DOUBLE is a float type, DECIMAL - not. I think I need to add a DECIMAL value. Am I right? Or in the future I still will have problems with accuracy?</p>