如何在pythonmysql中自动插入id？

Question

我想将数据插入数据库，但是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)

我有个错误：

Failed to insert into MySQL table Failed processing format-parameters; 'int' object is not iterable

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

Answer 1

在插入期间删除列id_settings，因为它是auto increment。你知道吗

 query = """INSERT INTO setting (name, address) VALUES (%s, %s) """