Python pyodbc 'execute only'

Question

我正在尝试使用pyodbc连接到本地MSSQL数据库，代码如下：

import pyodbc
conn = pyodbc.connect('Driver={ODBC Driver 17 for SQL Server};'
'Server=localhost;'
'Database=SampleDb;'
'Trusted_Connection=yes;')
cursor = conn.cursor()
cursor.execute = ('SELECT * FROM SampleDb.dbo.flights')
for row in cursor:
print(row)

得到以下错误：

cursor.execute = ('SELECT * FROM SampleDb.dbo.flights')
AttributeError: 'pyodbc.Cursor' object attribute 'execute' is read-only

Answer 1

cursor.execute是一个函数，所以你只需要调用它，而不需要为它分配一些东西

cursor.execute('SELECT * FROM SampleDb.dbo.flights')

来源：

• pyodbc维基