年前弄出来了,一直忘了更新
导入的不是mysql的了~
直接上代码~
import pyodbc
# Specifying the ODBC driver, server name, database, etc. directly
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=***;DATABASE=***;UID=***;PWD=***')
cursor = cnxn.cursor()
cursor.execute("select * from FX_MERCHANT WHERE NAME = '*** ")
row = cursor.fetchone()
if row:
print(row)
顺利结束~