I tried to install a module (from 9) to Odoo 10, it went halfway and I had some errors and did not install completely but tables of the addon were created. It gave issues to the whole Odoo installation, I don't know if this is common occurrence because I don't want something like to happen in production. If a module fails installing, it shouldn't affect the whole platform, right? 

How do I delete the addon from backend, (On GUI it said 'Cancel Install') there was no uninstall button. 

Will this suffice:

update ir_module_module set state='to remove' where name='module_name' and state='installed';