mysql - Cannot save data to database Python

Question

I have a table called category

TABLES["category"] = ("""
    CREATE TABLE category (
        category_id INTEGER NOT NULL AUTO_INCREMENT,
        category_name VARCHAR(120) NOT NULL,
        PRIMARY KEY (category_id)
    )
""")

when I ran INSERT INTO category (category_name) VALUES ('test') using mysql-connector-python, the value is not saved. But when I did this in my database directly, this was stored.

THank you in advance.

EDIT

cnx = mysql.connector.connect(user="root", database="my_db")
cursor = cnx.cursor()

Answer 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;