MySQL creating undesired auto incrementing primary keys

[ThibTrip]

When creating tables, SQLAlchemy will automatically set AUTO_INCREMENT on the first Integer primary key column which is not marked as a foreign key[...]

Source

We need to disable this!!

Code to reproduce the problem

The id 0 is somehow not even inserted! If one executes this code multiple times then MySQL will keep adding ids above 200 for some reason. I don't really understand MySQL's behavior but this is definitely not the desired behavior.

import pandas as pd
from pangres import upsert
from sqlalchemy import create_engine, text

# config, change connection string accordingly but it must be MySQL
engine = create_engine('mysql+pymysql://username:password@localhost:3306/db')

# upsert first df using pangres which creates the table automatically
df1 = pd.DataFrame({'id':[0, 1], 'name':['foo', 'bar']}).set_index('id')
upsert(con=engine, df=df1, table_name='test_pk_mysql', if_row_exists='update')

# upsert second df
df2 = pd.DataFrame({'id':[100, 200], 'name':['baz', 'qux']}).set_index('id')
upsert(con=engine, df=df2, table_name='test_pk_mysql', if_row_exists='update')

# read df back
with engine.connect() as connection:
    print(pd.read_sql(text('SELECT *FROM test_pk_mysql;'), con=connection, index_col='id').to_markdown())

id	name
1	bar
100	baz
200	qux