python连接数据库sql server格式_如何使用python连接到SQL server数据库？

根据您使用的sql数据库，可以pip安装pymssql for microsoft sql(mssql)、psycopg2 for postgres(psql)或mysqldb for mysql数据库

下面是一些使用它的例子

微软sqlimport pymssql

conn = pymssql.connect(server=server, user=user, password=password, database=db)

cursor = conn.cursor()

cursor.execute("SELECT COUNT(MemberID) as count FROM Members WHERE id = 1")

row = cursor.fetchone()

conn.close()

print(row)

博士后import psycopg2

conn = psycopg2.connect(database=db, user=user, password=password, host=host, port="5432")

cursor = conn.cursor()

cursor.execute('SELECT COUNT(MemberID) as count FROM Members WHERE id = 1')

row = cursor.fetchone()

conn.close()

print(row)

mysql数据库import MySQLdb

conn = MySQLdb.connect(host=host, user=user, passwd=passwd, db=db)

cursor = conn.cursor()

cursor.execute('SELECT COUNT(MemberID) as count FROM Members WHERE id = 1')

row = cursor.fetchone()

conn.close()

print(row)