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: ''