Cannot Save Data To Database Python

I have a table called category TABLES['category'] = (''' CREATE TABLE category ( category_id INTEGER NOT NULL AUTO_INCREMENT, category_name VARCHAR(120) NOT NUL

Solution 1:

If other queries work from Python, maybe adding commit after your insertion solves the problem.
something like this:

INSERT INTO category (category_name) 
VALUES ('test')
COMMIT;