解决此问题的最佳方法是使用pyodbc函数
executemany。
ds1Cursor.execute(selectSql)result = ds1Cursor.fetchall()ds2Cursor.executemany('INSERT INTO [TableName] (Col1, Col2, Col3) VALUES (?, ?, ?)', result)ds2Cursor.commit()
解决此问题的最佳方法是使用pyodbc函数
executemany。
ds1Cursor.execute(selectSql)result = ds1Cursor.fetchall()ds2Cursor.executemany('INSERT INTO [TableName] (Col1, Col2, Col3) VALUES (?, ?, ?)', result)ds2Cursor.commit()名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
