Update with PHP and MYSQL division

0

How do I UPDATE for all users of a database? For example:

UPDATE usuarios 
SET juros=investimento + investimento * 30 /100
WHERE id='89'

The bank will take the investment data and add 30%, but if I take the WHERE to add this value to all other users the following error appears:

MySQL Message: Documentation

  

# 1292 - Wrong truncation DOUBLE value: ''

    
asked by anonymous 12.12.2018 / 03:47

0 answers