error for delete query in MYSQL python

I have written the following query in mysql using python

self.sql.get_value("delete from devices where asset_id = '{}'".format(VARIABLE))

When I run this I am getting an error:

Unable to retrieve data : 'NoneType' object has no attribute 'getitem'

Things I have tried:

  1. Select query in same format works fine.
  2. Checked if VARIABLE is Null, it is not
  3. Tried this - delete from devices where asset_id = 'T1234'

Nothing worked. Any ideas on this would be helpful