Why autoincrement increases but new lines in the table do not appear?

Question

Python

Hello, I am using the mysql library in python, making a normal connection. When I try to execute a SELECT query, everything works, but when I execute an INSERT query, the table's auto-increment increases, but no new elements appear in the table.
Table structure:


A method that works great with SELECT queries:

def query(self, db, query, values=False):
        if values:
            cursor = db.cursor(prepared=True)
            cursor.execute(query, values)
        else:
            cursor = db.cursor()
            cursor.execute(query)
        result = []
        for data in cursor:
            result.append(data)
        return result

result2 = self.query(db, 'INSERT INTO admins (user_id, password) VALUES (%s, %s)', [id, new_password])

Answer 1

db.commit() must be done
And auto-increment is atomic - it grows even if the transaction is rolled back

Answer 2

Text values ​​in the query must be enclosed in quotation marks.
Auto-increment reserves the next value before each INSERT attempt. If the attempt fails, then the reserved value is not returned, and a gap appears in the list of auto-increment field values.