PYTHON安装sqlserver

年前弄出来了，一直忘了更新

导入的不是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)

顺利结束~