Oluderi - 6 months ago 36

MySQL Question

I am using Python 2.7 and MySQLdb. I get this error on this code:

`Value = 5`

x.execute("SELECT number from Testing where id ='%s';" % Value)

data = x.fetchall()

print (data)

data = data[0][0]

data = data + 0.5

x.execute(""" UPDATE Testing SET number = %s WHERE id = %s """, (data, Value))

conn.commit()

The error occurs on the line:

`data = data + 0.5`

`TypeError: unsupported operand type(s) for +: 'decimal' and 'float'.`

The number is a

`DECIMAL(8,1)`

Answer

There doesn't appear to be support for that operation, you will have to construct a `Decimal`

object first and add this:

```
In [132]:
import decimal
d = decimal.Decimal(23.0)
d = d + decimal.Decimal(0.5)
d
Out[132]:
Decimal('23.5')
```