如何在python mysql中自动插入id?

我想将数据插入数据库,但是python中的id如何自动递增呢?

在PHP中,我们仅通过使用默认值(如以下查询和插入的数据)来执行此操作:

mysqli_query($connection, "INSERT INTO setting VALUE(DEFAULT,'$name','$address')");

在PYTHON MYSQL中如何实现?

def insertSetting(name,address):
    try:
        connection = mysql.connector.connect(host='localhost', database='myDB', user='root', password='')
        cursor = connection.cursor()
        query = """INSERT INTO setting (id_setting, name, address) VALUES (DEFAULT, %s, %s) """
        records =(name,address)
        cursor.executemany(query,records)
        connection.commit()
        print("Inserted successfully")

    except mysql.connector.Error as error:
        print("Failed to insert into MySQL table {}".format(error))

    finally:
        if (connection.is_connected()):
            cursor.close()
            connection.close()
            print("MySQL connection is closed")

insertSetting(name,address)

我搞错了:

插入MySQL表失败,格式参数处理失败; “int”对象不可iterable

我希望结果是: 数据库中的id自动递增